Is there a way I can either ignore the blank cell and not return a value or just have a "0" in the cell? 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" |
---|---|
I always have Start Date, with set number of working days to complete various activities | Yet same formula for June 2019 with 21 working days gives the expected answer of 30-June-19 |
I am trying to calculate the number of days between dates but there are some cells where the 1st date may be blank.
30.
3