#### nniedzielski

##### Active Member

- Joined
- Jan 8, 2016

- Messages
- 472

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,

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: