Formula Modification Help

  • Thread starter Thread starter MM
  • Start date Start date
M

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
 
Hi

You can simply use =WEEKNUM(A2) to give you this. There is another argument
to WEEKNUM that you should read in Excel Help.
 
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
 
Hi
if A2 contains a date the simple formula
=WEEKNUM(A2)
will return the weeknumber for this date. Nothing more to do!
 
I guess the confusion comes because this is a leap year so
the simple formula may not be accurate....I don't think

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

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