HOW DO I RETURN THE WEEK NUMBER IN A CELL IN EXCEL from the =Today() function?

Question

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)

Answer 1

There are no arguments to enter for the =TODAY() or =NOW() functions. Both of these date functions draw their data from the computer's built-in clock. That may be why you are receiving the #REF! error.
What you can try is the DATEDIF() function. The syntax for it is: DATEDIF(start_date,end_date,unit).
I am including a site that explains the DATEDIF function more, and the units you can use with it.
I had another idea as well. Maybe if you made a separate sheet with each date on it and the week# beside it, then use a VLOOKUP function, that could give you a week# also.
Hope this helps. Feel free to email me also.

Answer 2

Excel Weeknum

Answer 3

Hi,

There's a function that does this. It's
WEEKNUM

Search for it in Excel's help for examples.

-Jim Gordon
Microsoft Mac MVP

MVPs are independent and do not work for Microsoft
http://mvp.support.microsoft.com/

Answer 4

Give WEEKNUM function a try,
general formula is WEEKNUM(serial_num,return_type)
e.g. =WEEKNUM(TODAY())
if the week begins on Sunday.
OR
=WEEKNUM(TODAY(), 2)
if the week begins on Monday.
OR
=WEEKNUM(A1+2)
if the week begins on Friday, and the date is in A1
=WEEKNUM(TODAY()+2)
if the week begins on Friday