Hi,
I want to take the number of days between 2 dates however when this is a negative number I want that to result in a zero.
The figures in cells L13 & L14 were both negative but I want these to be zero.
The formula I have used is:
=DATEDIF(IF(E13<$M$1,E13,$M$1+1),IF(E13>$M$1,E13,$M$1+1),"d")
Thank you
I want to take the number of days between 2 dates however when this is a negative number I want that to result in a zero.
The figures in cells L13 & L14 were both negative but I want these to be zero.
The formula I have used is:
=DATEDIF(IF(E13<$M$1,E13,$M$1+1),IF(E13>$M$1,E13,$M$1+1),"d")
Thank you