I have two dates in to different cells, I'm using the Formula below to show the amount of days between the two dates.
Column H is date stock was sentH10-G10
Column G is date stock came in
However, if there is not a date in H (eg, stock has not been sent out yet) then it comes out with a negative number. I want to extend my formula so that if the cell has 0 or less in it it will remain blank.
Can this be done??
I tried the code below and it doesn't work...
=IF(>0,"",H10-G10)
Bookmarks