I'm not trying to round up a calendar week date - I'm using a different range
based on my company's fiscal year of November to October.

The vlookup function resides in Worksheet A - therefore B2 is actually the
Start Date of the resource in Worksheet A.

a) I need to take the Start Date of the Resource from Worksheet A and
compare it against the calendar date range in Worksheet B
b) Worksheet B contains the 'fiscal calendar' breakdown by week (start date
of week, end date of week, week #). This fiscal calendar goes from November
to October ... and not January to December
c) I then need to find which week number the resource started on (because I
need the week number for another calculation)


" wrote:

Not sure how to fix your VLOOKUP, but why not just do:

=ROUNDUP(($B2-StartDate)/7,0)

where "StartDate" is a named cell, or if you don't want to use named
ranges try:

=ROUNDUP(($B2-WorksheetB!$A$1)/7,0)

in this example the start date would be in cell A1 of WorksheetB