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 sent![]()
Please Login or Register to view this content.
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...
![]()
Please Login or Register to view this content.
Bookmarks