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

Report
-
Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-
Hello,



Please I want to know how I can add 200 working days to a specific date to get a new date

2 replies

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

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

CCM 3984 users have said thank you to us this month

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

Glad to have helped you.

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