How to add 200 working days to a given date. [Solved]

- - Latest reply: Mazzaropi
Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
- 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
See more 

Your reply

2 replies

Best answer
Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
1
Thank you
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

Say "Thank you" 1

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

CCM has helped 2832 users this month

Hello Mazarropi,
Your solution was so on point! Thank you so much!!!
Respond to Mazzaropi
Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
0
Thank you
Bebs, Good morning.

Glad to have helped you.

Thanks for the feedback.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Respond to Mazzaropi