View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Auto calculate day of week to week of the year (not as serial)

=A1+7-WEEKDAY(A1)
--
David Biddulph

"oftenconfused" wrote in message
...
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!