Hi,
I have a "small" problem with dates-related formula.
Scenario
Period Range Worksheet
Column A - name of a period ie. Period01 2005, Period02 2005 and so on for the next 50 years (periods are 28 days, rather than monthly, so there are 13 periods in any given fiscal year)
Column B - start dates for each particular period, corresponding to column A
Column C - end dates for each particular period, corresponding to column A and B
Now the problem:
Calculation worksheet
In a separate worksheet I want to be able to enter ANY date (within 50 years range) in column A, and get a proper period and year match from Period Range worksheet ie. enter January 20, 2007 and get Period 01 2007 in column B.
I tried Index, Match combination - did not work.
The main problem is the the date typed most often falls within the range of start and end dates for any particualr period, rather than be an exact match to the start or end date for any particular period.
Any thoughts from you guys ????
Thanks in advance.
Bookmarks