| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date calculation problem
Tony,
Basically, +1 year and -1 day from the start: =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)-1) NickHK "TonyL" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date calculation problem
Thanks Nick. That did the trick
-- Tony "NickHK" wrote: Tony, Basically, +1 year and -1 day from the start: =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)-1) NickHK "TonyL" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
