If Then for date outcomes [Closed]

Report
-
Hello,

I am trying to set a conditional year end date outcomes.
1. If cell "A1" shows 10/31/2016, then I want cell "B1" to show year end 12/31/2016. Giving me two remaining months in 2016 before year end.
However,
2. If cell "A1" shows 01/01/2017, then I want cell "B1" to show year end 12/31/2017.
Giving me twelve remaining months in 2017 before year end.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!