Thread
:
Auto placement of date
View Single Post
#
5
Don Guillett
Posts: n/a
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
Reply With Quote