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

Bebs - Feb 27, 2018 at 08:24 AM - Latest reply: Mazzaropi 1829 Posts Monday August 16, 2010Registration dateContributorStatus May 7, 2018 Last seen
- 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

3 replies

Mazzaropi 1829 Posts Monday August 16, 2010Registration dateContributorStatus May 7, 2018 Last seen - Feb 27, 2018 at 09:58 AM
+1
Helpful
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
Was this answer helpful?  
Hello Mazarropi,
Your solution was so on point! Thank you so much!!!
Respond to Mazzaropi
Mazzaropi 1829 Posts Monday August 16, 2010Registration dateContributorStatus May 7, 2018 Last seen - Mar 1, 2018 at 06:21 AM
0
Helpful
Bebs, Good morning.

Glad to have helped you.

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