Formula Problem: Dates in Two Cells to be Subtracted!

[Antligen]

I have two dates in to different cells, I'm using the Formula below to show the amount of days between the two dates.

Please Login or Register  to view this content.

Column H is date stock was sent
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.

[daddylonglegs]

If you use this formula then the cell remains blank unless you have entries in both G10 and H10

=IF(COUNT(G10,H10)=2,H10-G10,"")

[dkorbat]

Try this:

Please Login or Register  to view this content.

Edit: Oops, late again. And yes, daddylongleg's approach is more elegant :D

[Antligen]

@ Daddylonglegs: Absolute star, worked perfectly!

Could you possibly show everyone here how you found your answer and let us know what the correct way tp lay out the formula was?

Just so everyone here can learn from it for next time

Thanks again!