| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update date every two weeks when a sheet is opened
Hi
I have a date in a cell (next delivery date). We get the item every second Tuesday. I am looking for (possibly) a function that updates this date every time the sheet opens, so currently the next delivery date is 05/05/09 and it will be delivered again on 19/05/09. So if the sheet is opened on 06/05/09 the date should read 19/05/09. Is this possible in Excel Your help would be much appreciated. Eddie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate a date, 10 weeks after a set date & return a specific da | Excel Worksheet Functions | |||
| Counting Closed Date < 2 weeks of Open Date etc | Excel Worksheet Functions | |||
| Display a update date on a sheet for a shared excel workbook | Excel Worksheet Functions | |||
| Automatic update of graph for 13 weeks | Charts and Charting in Excel | |||
| calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
Threaded Mode
