adding dates

  • Thread starter Thread starter teeb
  • Start date Start date
T

teeb

if i have a starting date in cell A1 and I want to add a full calenda
year less one day how do I do this for cell A2?

I've tried

=A1+365

but this doesn't take into account leap years.

:confused
 
Your question doesn't give enough information to resolve your essential
ambiguity: e.g., what is "a full calendar year less one day" after 29
February 2004?

You could use a function like

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

which, if A1 is 29 February 2004, will return 28 February 2005.

However, the same date will be returned if A1 is 1 March 2004. Is that
what you want? Or should a "full year" be 28 February 2005, less a day,
or 27 February 2005 (which, presumably, would also be returned when A1 =
28 February 2004)?
 

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

Create dates for year, allow for leap year 8
Date lists 3
convert date to yyyyddd format 2
If a date range contains a leap year (date) 14
multiple If's based on today's date 5
Calculating to add years - including leap year 4
Excel formula to incrementally increase a value by 1 every 365 day 2
Formula for Repeating the Same Date Each Year 6

Back
Top