Week

[DATTATREYA]

Hi All,
How to calculate week day example jan 5th to 10th jan jan 1st week 11th jan to 16th jan jan 2nd week like this I need pls any one help me

 

[Libra0099]

Try =WEEKNUM(E14,1)

 

[Libra0099]

Try =WEEKNUM(E14,1)

Please note that "The WEEKNUM function considers the week containing January 1 to be the first week of the year. However, there is a European standard that defines the first week as the one with the majority of days (four or more) falling in the new year. This means that for years in which there are three days or less in the first week of January, the WEEKNUM function returns week numbers that are incorrect according to the European standard."

 

[DATTATREYA]

Hi gohar,
Thanx 4 help We r using 2003 excel so could u pls help

 

[Libra0099]

Load the Analysis Toolpak Addin (Tools/Addins.../check the appropriate checkbox)