I am trying to show the Days between NOW() and the dates (dd/mm/yy) in either Column B or Column C - depending which one is not blank.
A B C 29/03/10 01/04/10 29/03/10 02/04/10 29/03/10 30/04/10 29/03/10 31/03/10 29/03/10 03/04/10
I currently have the formula below and then drag it down, but it obviously means I need to go back and correct the "errors."
I'm now using that instead of
=DAYS360(). It gives me more accuracy (I think).
I always forget how to nest this type of null/blank thing, so any help or pointers to remember would be appreciated.