How to add 200 working days to a given date.
Solved/Closed
Bebs
-
Feb 27, 2018 at 08:24 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 1, 2018 at 06:21 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 1, 2018 at 06:21 AM
Hello,
Please I want to know how I can add 200 working days to a specific date to get a new date
Please I want to know how I can add 200 working days to a specific date to get a new date
Related:
- How to add 200 working days to a given date.
- How to add songs to sound picker - Guide
- How to add @ in laptop - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- Skype last seen days ago - Guide
- How to add 90 days to a date in excel - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 27, 2018 at 09:58 AM
Feb 27, 2018 at 09:58 AM
Bebs, Good morning.
Scenario:
A1 --> SPECIFIC DATE --> eg.: 02/25/2018
Try to use:
B1 --> NEW DATE --> =WORKINGDAY(A1, 200)
B1 --> 11/30/2018
Format B1 as DATE
Is that what you want?
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Scenario:
A1 --> SPECIFIC DATE --> eg.: 02/25/2018
Try to use:
B1 --> NEW DATE --> =WORKINGDAY(A1, 200)
B1 --> 11/30/2018
Format B1 as DATE
Is that what you want?
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 1, 2018 at 06:21 AM
Mar 1, 2018 at 06:21 AM
Bebs, Good morning.
Glad to have helped you.
Thanks for the feedback.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Glad to have helped you.
Thanks for the feedback.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Mar 1, 2018 at 01:11 AM
Your solution was so on point! Thank you so much!!!