Formula Modification Help

[MM]

How do I modify this formula to give me the week number in
the year instead of the week number of the month based on
a date enter....example...
If I enter 5/20/2004...the return value is 4 (week 4 of
May)..I wnat to show the week number in the year...

Thanx

=WEEKNUM(A2)-WEEKNUM(DATEVALUE(MONTH(A2)&"/1/"&YEAR(A2)))+1

 

[Frank Kabel]

Hi
=WEEKNUM(A2)

 

[Andy B]

Hi

You can simply use =WEEKNUM(A2) to give you this. There is another argument
to WEEKNUM that you should read in Excel Help.

 

[MM]

Sorry Frank but I don't understand....the formula I have
uses weeknum but it returns the week of the month...so do
I use year instaed of month....take a look at how it is
now...do I flip year and month??
=WEEKNUM(A2)-WEEKNUM(DATEVALUE(MONTH(A2)&"/1/"&YEAR(A2)))+1

 

[Frank Kabel]

Hi
if A2 contains a date the simple formula
=WEEKNUM(A2)
will return the weeknumber for this date. Nothing more to do!

 

[MM]

I guess the confusion comes because this is a leap year so
the simple formula may not be accurate....I don't think

D

 

[MM]

I flipped month and year at it gave me the correct value

=WEEKNUM(A763)-WEEKNUM(DATEVALUE(YEAR(A763)&"/1/"&MONTH
(A763)))+1

 

[Frank Kabel]

Hi
what a correct weeknumber is depends on your definition. See:
http://www.cpearson.com/excel/weeknum.htm