nniedzielski
Well-known Member
- Joined
- Jan 8, 2016
- Messages
- 598
- Office Version
- 2019
- Platform
- Windows
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: