I'm new to VBA and trying to write a macro/code to compare list of dates to range of dates. In my spreadsheet, Col A shows list of due dates, Col D shows start dates, Col E shows end dates, Col F shows the corresponding week number of inclusive Start Date and End Date, i.e. 1, 2, 3, 4 up to 15 weeks. I want to compare the date on Col A to the Col D (Start date) and Col E (End date) if it matches and within the date range between start and end dates, put the week number on Col B. However, if it does not match to the range date, compare it to the next week range (loop?) until it find the match week range and put the corresponding week number on Col B. Any suggestions will be appreciated.