weeknum

**kiany406** · 11-22-2009, 05:03 PM

Dear Sir,
In excel 2003 i need to know the formula to see week number of current month and current year.

**rwgrietveld** · 11-22-2009, 05:08 PM

Please specify the location as Europe / USA / Japan have different standards

**rwgrietveld** · 11-22-2009, 05:27 PM

For me (Netherlands) it is

Please Login or Register  to view this content.

A1 is the date of the thursday of this week.

Example: Today sunday 22 nov 2009
Thurday of this week was 19 nov 2009 (=A1)

Note that we start the week with a monday.

**Richard Buttrey** · 11-22-2009, 05:30 PM

Originally Posted by kiany406

Dear Sir,
In excel 2003 i need to know the formula to see week number of current month and current year.

Hi,

Assuming Sunday is the start of the week and 1st January is the start of the year.

Week number in month

Please Login or Register  to view this content.

Week number in year

Please Login or Register  to view this content.

HTH

**rwgrietveld** · 11-22-2009, 05:34 PM

To automate this fully

Please Login or Register  to view this content.

where A1 is the Date of which you would like to know the weeknumber.

**rwgrietveld** · 11-22-2009, 05:38 PM

Richard,

Exactly my point. Your solution is 48 where mine is 47. MS WEEKNUM() is according USA.

Even

Please Login or Register  to view this content.

gives a different outcome.

See years 2005/2006 e.g.

**kiany406** · 11-24-2009, 03:48 PM

Originally Posted by rwgrietveld

Please specify the location as Europe / USA / Japan have different standards

Here our week starts from Sunday

**teylyn** · 11-24-2009, 04:34 PM

Here our week starts from Sunday

That's not the point. It's more about: if the first day of the year is, say, a Wednesday, is that "half week" treated as week 1 or week 0? That's what different countries do in a different way. Some count the first "full" week as week 1 only, others regard the week with the 1/Jan as week 1

**kiany406** · 11-25-2009, 03:03 PM

Originally Posted by teylyn

That's not the point. It's more about: if the first day of the year is, say, a Wednesday, is that "half week" treated as week 1 or week 0? That's what different countries do in a different way. Some count the first "full" week as week 1 only, others regard the week with the 1/Jan as week 1

Yes Sir,
Here with us is the first full week is number (week 1) that starts from first Sunday till Saturday.