Return Sundays date of current week
 

I dont know why Im having such a hard time wrapping my head around this
one... but Im looking for a function that will return Sundays date
(mm-dd-yyyy) of the current week.

In other words, if I opened up the worksheet today, the field should
automatically have "10-09-2005" in it.

Thanks a bunch.


--
durex
------------------------------------------------------------------------
durex's Profile: http://www.excelforum.com/member.php...o&userid=27857
View this thread: http://www.excelforum.com/showthread...hreadid=475869

NM... I figured it out...


Code:
--------------------
=TODAY() - (WEEKDAY(TODAY())-1)
--------------------


--
durex
------------------------------------------------------------------------
durex's Profile: http://www.excelforum.com/member.php...o&userid=27857
View this thread: http://www.excelforum.com/showthread...hreadid=475869