Auto Date based on an Entry

[karimel_romeo]

Hi Guys,

I am trying to get a cell to auto populate with a date based on the date entered in another cell.

Example:

If Cell A1 has 01/15/2014 (US format)
Then cell A2 should automatically put 12/31 of whatever year is entered in A1 (i.e 2014)

I have so far used: =DATE(YEAR(TODAY()),12,31) But that enters the 12/31 correctly, but not the right year (obv 2013 is showing instead of 2014)

The attached file details the requirement better.

I am sure one of you knows how to correct this pretty easily.

Thanks!