Hi,
I'm looking for some help with two formulas I'm trying to write. I have a list of date ranges, along with a Week Number and Release Number, and based upon today's date need to identify both, for example:
Start End Week Release
--------------------------------------------------
01/07 31/07 1 A
01/08 31/08 2 B
So based on today's date (12/07) I would get 1 and A.
Any help would be appreciated.
If you have start dates in A2:A10, end dates in B2:B10, Week Numbers in C2:C10 and Release Numbers in D2:D10 then try this formula to get the Week number
=LOOKUP(TODAY(),A2:A10,C2:C10)
you can do the same for Release Numbers by changing C2:C10 to D2:D10
This assumes that you will always have a range including today's date and that date ranges are contiguous, i.e. there are no gaps
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks