Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto dating after entering the first date | Excel Worksheet Functions | |||
how do i set an auto date function in excel or word? | Excel Discussion (Misc queries) | |||
assign auto number and auto date | Excel Discussion (Misc queries) | |||
auto entry of a date | Excel Worksheet Functions | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |