| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating dates Using Autofill
Using formula =DATE(YEAR(K1),MONTH(K1+1),DAY(K1) starting with 01/01/2004 an
error is generated at 01/01/2005. However if I unclick Transition Formula Evaluation and Transition Formula Entry in the Tools/OPtions/Transition tab autofill works but formulae in other cells don't work. Anyone got a solution to this Am using Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generating Calender in Excel giving start & end dates | Excel Worksheet Functions | |||
| autofill on fixed dates | Excel Worksheet Functions | |||
| Can autofill, as in months or dates, go to the end of the spreads | Excel Worksheet Functions | |||
| generating dates | Excel Worksheet Functions | |||
| autofill next sheet with next set of dates | Excel Worksheet Functions | |||
Threaded Mode
