I use the following formulas to count the number of days between two dates, and if one column is blank, to show a blank cell, otherwise the number of days, on in a nearby cell "Not Received".
I would like to show something like "Not Received" if the cell is returned blank. I have got this working in an adjacent cell, but would like to combine the two formulas to show in the same cell.
Hope this makes sense?
Please could someone help me combine the two formulas to show the desired result, or is it not possible?
Solved by S. J. in 29 mins