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

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

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