Hello,
I am trying to calculate the difference between 2 work dates but not including the actual start or end date
Mind you I am also not including Weekend or holidays so just M-F
so for example if I have start date 6/15/17, and end date on 6/23/17 I would want my formula to give me an answer of 5, F, M, Tue, W, Th
I do not want to include 6/15 which is a Thursday or 6/23 which is a Friday
I have come up with this formula
=IF(D11="","",NETWORKDAYS.INTL(C11, D11,,)-2)
Where if D=11 is not populated it would return a blank cell, the two cells I am calculating the difference in dates would be C11 which is start date and D11 which is end date)
I have added the -2 at the end which does remove the start and end date but the problem is if I have a date that starts on 6/15/17 and ends on 6/15/17 then it would return a negative number.
if there is no actual way of just calculating the dates without the start and end date being included, is there a way I can have the formula return a 0 instead of a negative. I have also played around with the =MAX(0 option but I do not want to go that route because then it would make all cells 0 when in reality I want them blank unless the dates are filled in
Sorry for my rant, I am just so confused.
Thank you
Bookmarks