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