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
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!!!!
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!!!!
Related:
- Set a conditional year end date outcomes
- How to set auto redial on android - Guide
- How to set whatsapp date and time - Guide
- Winrar set password not working - Guide
- How to set viber offline - Guide
- How to set nitro as default - Guide
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
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
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