# Flaw in certain Date Math functions?

Hewlett-packard / Dw232a-aba a510n
October 25, 2011 at 19:07:47
Specs: Microsoft Windows XP Home Edition, 2.1 GHz / 1983 MB
 Was playing around and found:If you enter the dates below in Column A:``` A 1) 2/27/2011 2) 2/28/2011 3) 3/1/2011 4) 3/2/2011 5) 3/3/2011 ```In Column B enter the Formula: =SUM(A1+365) or just =A1+365drag down 5 cells.In Column C enter the Formula: =DATE(YEAR(A1)+1, MONTH(A1), DAY(A1))drag down 5 cells.This formula is very often suggested for adding years to a date.In Column D enter the Formula: =EDATE(A1,12)drag down 5 cells.This formula is sometimes suggested for adding years to a date.If you notice, the two Function Formulas, =DATE() and =EDATE() give you the wrong answer.February 2012 is a Leap YearThere is a February 29, 2012, but the Function formulas do not account for it.Only doing it the old fashioned way of actually adding 365 days to a date works.MIKEhttp://www.skeptic.com/

See More: Flaw in certain Date Math functions?

#1
October 26, 2011 at 01:54:38
 OK with LibreOffice Calc (Open Office)

Report •

#2
October 26, 2011 at 06:35:23
 wizard-fred,Does Open Office have the =DATE() and =EDATE() functions, or something similar?MIKEhttp://www.skeptic.com/

Report •

#3
October 26, 2011 at 07:07:08
 Same functions Most of the excel functions. Can read XLS.

Report •

Related Solutions