Hewlett-packard / Dw232a-aba a510n

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/2011In 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

OK with LibreOffice Calc (Open Office)

wizard-fred, Does Open Office have the =DATE() and =EDATE() functions, or something similar?

MIKE

Same functions Most of the excel functions. Can read XLS.

Ask Your Question

Weekly Poll