Here is the formula I use:
=DATEDIF(B6,TODAY(),"D")
to calculate # of days from date I entered.
However when I left the cell blank, it gives it a value of 38607.
How can I get it blank if I don't enter a date? It affect the whole spreadsheet.
Thanks.
Bookmarks