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+365
drag 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 Year
There 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.

MIKE

http://www.skeptic.com/


See More: Flaw in certain Date Math functions?

Report •


#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?

MIKE

http://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


Ask Question