M
Mrs H
I need a formula to count the number of days from a date in a cell to the
current date if another cell is null.
Example:
Date Sent Date Received Days Past Due
1/29/09 Null or blank
Also I have this formula:
=TODAY()-K15 but if the cell it refers to is null, it returns a number
39849 instead of zero - why is this?
current date if another cell is null.
Example:
Date Sent Date Received Days Past Due
1/29/09 Null or blank
Also I have this formula:
=TODAY()-K15 but if the cell it refers to is null, it returns a number
39849 instead of zero - why is this?