calculate days between ordering and receiving, return 'In transit' if no date in receive

[Kymmaree]

Hi,

I need a formula for Professional Plus 2013 and I really know nothing about spreadsheets etc
I have a 10 column sheet, in column A is the date an order was made, in column I is the
date the item/s were received. Row 1 is column headings.
I would like Column J to show the delay days between ordering and receiving and if the item
has not been received, (therefore column I will be empty) to display 'In transit'.

Can anyone help me to do this?

Thanks
Kym

[gmr4evr1]

Try this in the first cell in column J that you want the info displayed in...then drag down to other cells in column J

Please Login or Register  to view this content.

[Kymmaree]

Absolutely perfect!!!! Thanks so much. MWAH!

[gmr4evr1]

No problem, glad it worked for you.