Day or Arrival, Plus 2

[nniedzielski]

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,

 

[Scott Huish]

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

=WORKDAY(C16,2,M16:M28)

 

[nniedzielski]

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]

That's what you asked for:

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]

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]

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