? How to pull system date then set it to previous sunday

[_Bigred]

I would like to have a cell on a worksheet, grab the date from my computer
and do the
following:


E.g If my system clock shows it's Wed Oct 24, 2007 -->
I would like the cell to reflect the previous sunday (Sunday
10/21/07)

If my system clock shows it's Sun Oct 28, 2007 --> then have the
cell show 10/28/07
If my system clock shows it's Sat Oct 27, 2007 --> then have the
cell show 10/21/07

(I would always be using the sunday prior to the date, unless the day
the sheet is open is sunday. )

this is so anytime the worksheet gets open and a user prints it, it will
updated without user input/manipulation.


TIA,
_Bigred

 

[Pete_UK]

Try this:

=TODAY()-WEEKDAY(TODAY())+1

You might like to have a custom format on the cell - "ddd, mm/dd/
yyyy" (without the quotes).

Hope this helps.

Pete

 

[_Bigred]

Pete that worked like a charm.

Thank You for time and assistance.
_Bigred

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete