| Yet same formula for June 2019 with 21 working days gives the expected answer of 30-June-19 | I've tried adding an IF formula, but can't get it right |
|---|---|
| If the deference between the two dates are "0 to 5" calendar days than the final result is "Y" and if the deference between the two dates are "greater than 5" or "less than 0" than final result is "N" | Is there a way I can either ignore the blank cell and not return a value or just have a "0" in the cell? INTL START,DAYS,WEEKEND,HOLIDAYS also causes issues, we work Sun-Thu, so weekend option is 7, yet this formula isn't consistent either, May 2019 has 22 working days DAYS , this makes the result 02-Jun-19, which is the 2nd working day of June! I am trying to calculate the number of days between dates but there are some cells where the 1st date may be blank |
I always have Start Date, with set number of working days to complete various activities.
.
16