Auto placement of date
 

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

Carolyn E. Weiss

try
=F7-WEEKDAY(F7-1)+7-(WEEKDAY(F7)=6)*7

--
Don Guillett
SalesAid Software

"Carolyn" wrote in message
...
Is there a way to have the date of the Sunday following the date the
spreadsheet is opened to automatically entered?

Carolyn E. Weiss

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

"Carolyn" wrote in message
...
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:

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

"Carolyn" wrote in message
...
Is there a way to have the date of the Sunday following the date the
spreadsheet is opened to automatically entered?

Carolyn E. Weiss

glad it helped

--
Don Guillett
SalesAid Software

"Carolyn" wrote in message
...
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

"Carolyn" wrote in message
...
Is there a way to have the date of the Sunday following the date the
spreadsheet is opened to automatically entered?

Carolyn E. Weiss