Hi I am trying to use a list of dates to display what the current week number would be depending on a cell entry and a start date, please see attached sheet for details.
JD
Hi I am trying to use a list of dates to display what the current week number would be depending on a cell entry and a start date, please see attached sheet for details.
JD
How the week no is 7 for attached file
Please consider adding a * if I helped
That would be displayed as the current date activates the week number depending if that any of that particular weeks dates fell in week 7
basically what i need is a cell to display the most current week number from a list of dates
John,
how is Week 7 the most current week if your current date is July 14, 2013 which isnt even listed on your lookup tab?
Life's a spreadsheet, Excel!
Say thanks, Click *
sorry the 1st date in the list should have been may 1st 2013
Maybe
="Week "&INT((C2-A2)/7)
thats great thank you !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks