How to add 200 working days to a given date.
Solved/Closed
Bebs
-
27 Feb 2018 à 08:24
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 1 Mar 2018 à 06:21
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 1 Mar 2018 à 06:21
Related:
- How to add 200 working days to a given date.
- Excel add days to date - Guide
- Vlc 200 volume - Guide
- How to add a checkmark in word - Guide
- How to add at the rate in laptop - Guide
- How to add authorized user t mobile - Guide
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
27 Feb 2018 à 09:58
27 Feb 2018 à 09:58
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
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
1 Mar 2018 à 06:21
1 Mar 2018 à 06:21
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
1 Mar 2018 à 01:11
Your solution was so on point! Thank you so much!!!