Find week Number within a month 1

[dmuroff]

Hi,

I am trying to find a way to evaluate which week of the month a date belongs to. This is for a function in Excel.

I know that the weeknum function will return the week of the year but is there a way to find the week of the month?

for example:
1/1/2005 is week 1 for January
2/1/2005 is week 1 for February

Any ideas will be greatly appreciated.

Thanks in advance,

Dan

 

[PHV]

Something like this ?
1 + (Day(yourDate) \ 7)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dmuroff]

That's it!

Thanks for the quick reply!


Dan