Set a conditional year end date outcomes

Closed
Kevdfw - 7 Jul 2016 à 00:49
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 7 Jul 2016 à 08:03
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. This gives us two remaining months in 2016 before year end.
However,
2. If cell "A1" shows 01/01/2017, then cell "B1" ideally would show year end 12/31/2017.
Giving twelve remaining months in 2017 before year end.

Thanks so very much!!!!


1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
7 Jul 2016 à 08:03
kevdfw, Good morning.

Try to use:

B1 -->
=DATE(YEAR(A1),12,31)

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão