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.
![]() |
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.
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.
You can use a cell reference, too:
=WEEKNUM(A1)
All times are GMT -7. The time now is 08:03 AM. |