I need excel help!
Here is the data
My 2008 year for work starts on Friday December 28. Weeks are from Friday to Friday (thursday 11:59pm really i guess, but not important, sorry!)
-Wednesdays are the due dates for weekly submissions
Anything submitted by Wednesday "places" for that week
So if on Jan 2(wednesday) I Submit 3 cases,
I would have 3 cases for week 1
So to the Real Question
How do I return the # of the week in a cell , from the =TODAY() function
I want to be able to open my spreadsheet and see what number week it is and how many weeks are left for the year, I will also use the Week Number to calculate YTD progress on a weekly, monthly and quarterly basis. SO that is why I need to automatically calculate the Week Number of the Year.
PLEASE HELP I AM in ######NUM #######REF! hell (some excel humor for you)
2007-12-19
10:19:04
·
4 answers
·
asked by
ogary245
1
in
Software