Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date calculation problem
Cell A1 contains a date & I want to calculate to the end of that of that year
period i.e. cell A1 contains 01/04/2007 & I want cell A2 to be 31/03/2008 (ddmmyyyy format). =A1+364 won't do as this does not take into account leap years. TIA -- Tony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Calculation problem | Excel Worksheet Functions | |||
Date Calculation problem | Excel Discussion (Misc queries) | |||
Date Calculation Problem | Excel Worksheet Functions | |||
Date Calculation Problem | Excel Discussion (Misc queries) | |||
Date Calculation Problem | Excel Programming |