Thread: Auto calculate day of week to week of the year (not as serial)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
oftenconfused oftenconfused is offline
external usenet poster
  
Posts: 3
Default Auto calculate day of week to week of the year (not as serial)
Here's what I'm looking to do:

Today is 23 June 2008. Based on a SUN-SAT week, 23 June 2008 is the week of
28 June 2008. (I want to return the actual date, not the week's serial
number.) How can I set this up so it calculates this automatically?

Much thanks!

Reply With QuoteReply With Quote