Current week

T

Tom

Hi,

Date() present today's date.
How do I present today's week (which week between 1 and 52)?

TIA,

Tom
 
F

fredg

Hi,

Date() present today's date.
How do I present today's week (which week between 1 and 52)?

TIA,

Tom
Click to expand...

Look up the DatePart function in VBA help.

DatePart("ww",Date())

Also note that the DatePart function hsa various arguments to set the
first week of the year as well as the first day of the week. January
1st and Sunday are the defaults.
 
R

Ron

Thanks for the tip, It supposed to be it, but instead of the week number I
get 1/29/1900.
Any ideas?

Thanks,
Tom
 
J

John Spencer

That appears to be the conversion of the week number to a date. Are you
formatting the results of the DatePart function to a date format?

Ron said:
Thanks for the tip, It supposed to be it, but instead of the week number I
get 1/29/1900.
Any ideas?

Thanks,
Tom
Click to expand...
 
Top