Auto calculate day of week to week of the year (not as serial)

[oftenconfused]

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!

 

[Pete_UK]

If your date is in A1, use this:

=A1+7-WEEKDAY(A1)

Hope this helps.

Pete

 

[David Biddulph]

=A1+7-WEEKDAY(A1)

 

[oftenconfused]

Thanks!

If your date is in A1, use this:

=A1+7-WEEKDAY(A1)

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for taking the trouble to feed back.

Pete