One formula that convert any given date to week no.of the year. [Archive]

mykonen

Oct 29, 2009, 12:14 AM

What are the formula in excel to convert any given date to the week of that date in that year.

Example: 29 October 2009 is Week 44.

TQ.

Khalil.

ebaines

Oct 29, 2009, 06:03 AM

Try this:

=WEEKNUM(DATE(2009,10,29),1)

If you get a #NAME? Error that means you need to install the Analysis Toolpack Add-In into Excel.

JBeaucaire

Oct 30, 2009, 04:18 PM

You can use a cell reference, too:

=WEEKNUM(A1)