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!
|