How do I calculate week number?

[telescreamer]

I know how to calculate it creatig a formula (date minus first day of the year divided by seven)

Is there another easy way to do that?

 

[Yogi Anand]

Hi telescreamer:

Welcome to the Board!

You can use the WEEKNUM function -- see the worksheet simulation.

Book1
	A	B	C	D
1
2	10/10/2002	41	41
3		weeknumber--weekbeginningwithSunday	weeknumber--weekbeginningwithMonday
Sheet1

Regards!

Yogi

Edit: corrected typo
This message was edited by Yogi Anand on 2002-10-10 13:38

 

[Mark W.]

Or, you could see...

http://216.92.17.166/board/viewtopic.php?topic=24947&forum=2&2

 

[Yogi Anand]

Hi Mark:

Thanks for pointing out this post was a duplicate -- I had not seen the first posting.

Regards!

Yogi