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

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

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Feb 27, 2018 at 09:58 AM
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

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1770 users this month

Hello Mazarropi,
Your solution was so on point! Thank you so much!!!
Respond to Mazzaropi
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Mar 1, 2018 at 06:21 AM
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