Set a conditional year end date outcomes

Closed
Kevdfw - Jul 7, 2016 at 12:49 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 7, 2016 at 08:03 AM
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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 7, 2016 at 08:03 AM
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
1