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
[email protected]
"Carolyn" <[email protected]> wrote in message
news:[email protected]...
> 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
> [email protected]
> "Carolyn" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> [email protected]
> "Carolyn" <[email protected]> wrote in message
> news:[email protected]...
> > 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
[email protected]
"Carolyn" <[email protected]> wrote in message
news:[email protected]...
> 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
> > [email protected]
> > "Carolyn" <[email protected]> wrote in message
> > news:[email protected]...
> > > Is there a way to have the date of the Sunday following the date the
> > > spreadsheet is opened to automatically entered?
> > >
> > > Carolyn E. Weiss
> >
> >
> >