MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date of Year End


Posted by SJC on February 23, 2001 3:24 PM

In cell A1, I have the date 02/03/1945. In cell D1, I would like a formula that returns the date of the last day of the year in A1, i.e., 12/31/1945. In cell D2, I would like another formula that returns the date of the last day of the year before the year in A1, i.e., 12/31/1944. Can someone help me? Thanks in advance.


Posted by Mark W. on February 23, 2001 3:48 PM

In cell D1, enter =DATE(YEAR(A1),12,31)
In cell D2, enter =DATE(YEAR(A1)-1,12,31)