end of year

Posted by mcarter973 on August 08, 2001 1:12 PM

instead of hard coding the prior year end date, i would like to create a formula that is derived from a month-end date during the year.

column A: 6/30/01
column B: 12/31/00 (need a formula).

and next year when column A is 2/28/02, then column B s/b 12/31/01.

i can't figure it out.

thanks.

Posted by Barrie Davidson on August 08, 2001 1:19 PM

Try this in column B
=DATE(YEAR(A1)-1,12,31)

Barrie

Posted by Aladin Akyurek on August 08, 2001 1:26 PM

In B(1) enter: =DATE(YEAR(A1)-1,13,0).