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.