Display # of days between dates even if cell is blank or has "n/a" in it

I have a log that I am working on and need some assistance.

Row E reflects date received
Row F reflects date to Engineer
Row G reflects date back from engineering

Each cell in these rows contains a date, "N/A', or is blank. I need a formula that can either include all 3 dates (E, F, & G) or just the dates in row F and G but it must also take into account if the cell is blank or contains "N/A" and still return # of days between cells.

I suppose if needed row E could be used if F & G are either blank or contain "N/A"

Anyone have idea for a formula for this?RFI LOG.xlsx

Hi geturbanized,

Try below formula:-

Formula:

Please Login or Register  to view this content.

See attached:- RFI LOG.xlsx


Regards,
DILIPandey

<click on below 'star' if this helps>

Okay.. I tried copying your logic only from post #1. No issues.. suggest you to post your expected output manually and will try to obtain that using formulas. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

I saw that column I has already got results fetched by formula.. so are those the number which you are looking for since I requested;-

suggest you to post your expected output manually and will try to obtain that using formulas. thanks.

Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>