Hi
try
=TODAY()-WEEKDAY(TODAY())+1
and format this as date

"macamarr" wrote:

In my Worksheet I use a cell for the week of. What I would am attempting to
do is have the cell show the Sunday date of the week that we are in. Example:
Today is 11/16/04 so the week of date should be 11/14/04. The following week
when the template is opened should show 11/21/04.