Week Of Year 2

[NavAmmo]

Is there a weekofyear type function for determining what week number (1-52) a given date occurs in? If not, does anyone know of an acceptable alternative to get the same data?

 

[PHV]

A starting point:
MsgBox Format(Date(), "ww", , 2)

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

 

[dilettante]

Or use the DatePart() function, which has similar parameters but returns a number.

Note that you can specify what day of the week is the first day of a week, as well as how the "first week" of the year is defined.

 

[NavAmmo]

Thanks a million PHV! So great to have people with such expertise who don't mind answering the "dumb" questions and pointing newbies like me in the right direction! I LOVE THIS FORUM!!

 

[NavAmmo]

Thank you dilettante!