Auto placement of date

[Carolyn]

Is there a way to have the date of the Sunday following the date the
spreadsheet is opened to automatically entered?

Carolyn E. Weiss

[Don Guillett]

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

[Carolyn]

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
>
>
>

[Carolyn]

Don:

I put the TODAY function in F7 and got 05/1/05 in the cell I put this
formula. Neat!
Many thanks.

Carolyn
"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
>
>
>

[Don Guillett]

glad it helped

--
Don Guillett
SalesAid Software
donaldb@281.com
"Carolyn" <Carolyn@discussions.microsoft.com> wrote in message
news:02849100-F220-4FFC-A590-32008B65055C@microsoft.com...
> Don:
>
> I put the TODAY function in F7 and got 05/1/05 in the cell I put this
> formula. Neat!
> Many thanks.
>
> Carolyn
> "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
> >
> >
> >