Set a conditional year end date outcomes [Closed]

Report
-
Posts
1927
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 17, 2021
-
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 reply

Posts
1927
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 17, 2021
143
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!