Thank you. Is there a value I should have in F7? I get #NUM in the cell I
put this formula in.


"Don Guillett" wrote:

> try
> =F7-WEEKDAY(F7-1)+7-(WEEKDAY(F7)=6)*7
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "Carolyn" <Carolyn@discussions.microsoft.com> wrote in message
> news:C784E3A9-698F-4E5C-8199-B27F60B28871@microsoft.com...
> > Is there a way to have the date of the Sunday following the date the
> > spreadsheet is opened to automatically entered?
> >
> > Carolyn E. Weiss
>
>
>