DATES
 

I need a formula that will let a cell always automatically update and
ONLY show the date of the last Sunday. Any assistance would be
appreciated. Thanks.

Jay Dean

DATES
 

Put this formula in a cell

=TODAY()-WEEKDAY(TODAY(),3)-1



--

Regards,

Peo Sjoblom

"Jay Dean" wrote in message
om...
I need a formula that will let a cell always automatically update and
ONLY show the date of the last Sunday. Any assistance would be
appreciated. Thanks.

Jay Dean

DATES
 

My Pleasure..

Peo

--

Regards,

Peo Sjoblom

"jay dean" wrote in message
...

Thanks. It works !

Jay Dean


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!