Date calculation problem

T

TonyL

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
 
N

NickHK

Tony,
Basically, +1 year and -1 day from the start:

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)-1)

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Up Calendar To Account For Leap Years 2
Looking for a Date forming function 3
Compare shorter date range against longer date range 2
Date lists 3
Open txt file without changing date 1
Calculate if 2 times differ by 24 hours? 8
Send email to a email address 7 days before the due date 1
Subtracting time...again 2

Top