View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Micquia Micquia is offline
external usenet poster
 
Posts: 1
Default List of Dates- Assign Week Number??


I have a list of random dates between 09/01/05 and 07/01/06. I would
like to assign a week number to each date. For example, I would like it
to be week 1 if the date is between the dates of 09/01/05 and 09/07/05.
Is there any simple way of going about this? I think I have done
something like this before but it has been a while.


--
Micquia
------------------------------------------------------------------------
Micquia's Profile: http://www.excelforum.com/member.php...o&userid=36252
View this thread: http://www.excelforum.com/showthread...hreadid=560450