Current week

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi,

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

TIA,

Tom
 
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.
 
Thanks for the tip, It supposed to be it, but instead of the week number I
get 1/29/1900.
Any ideas?

Thanks,
Tom
 
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...
 
Back
Top