# Day or Arrival, Plus 2

#### nniedzielski

##### Active Member
I am trying to build a formula in excel that will compare two dates.

I am using =NETWORKDAYS formula to calculate the number of days in between, and that is working great.

My problem is, in Cell C1, I am entering a date of arrival. What I need is:
If the arrival date is a workday, then it counts it as 1 andadds two more work days to it.
However, if it is not a workday, then it goes to the next workday and counts that day as 1 and then adds two more work days to it.

Essentially, day of arrival plus 2.

Right now my formula is =WORKDAY(C16,1,M16:M28), but if theday of arrival is a workday, it goes to the next one anyways, and I lose a day in my calculation.

Thanks for any help possible,

Last edited:

#### Scott Huish

##### MrExcel MVP
Maybe I'm missing something but wouldn't that be:

=WORKDAY(C16,2,M16:M28)

#### nniedzielski

##### Active Member
I need my Start Date to start on Day 1 if its a work day. you just added 2 days to my start date.

#### Scott Huish

##### MrExcel MVP
If the arrival date is a workday, then it counts it as 1 andadds two more work days to it.
However, if it is not a workday, then it goes to the next workday and counts that day as 1 and then adds two more work days to it.
Can you please provide a sample of what you need exactly?

#### Tetra201

##### MrExcel MVP
See if the following formula works for you:

=WORKDAY(C16-1,1,M16:M28)

Here, if C16 is a workday, the formula returns the same date. If C16 in a non-work day, the formula returns the next workday date.

#### nniedzielski

##### Active Member
that worked for the cell in question, but threw the rest of the cells out of whack, I don't want to start a new question in side this thread, so I will have to start over