View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Extracting week number from Today() function

How do you count your week numbers? Is Week 1 from January 1st to January
7th? Or is it from the first Sunday of the year (that is, the Sunday of the
week contain January 1st) to that Saturday?

--
Rick (MVP - Excel)


"BillyPilgrim" wrote in
message ...
Hi guys.

Is there a string I can enter into a cell that shows the week of the
year based on the current day?