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

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History