Need to count number of days

AliT

I need to count the number of days from today to a certain date in a column.

=TODAY() - IF([Assigned Date]@row <> "", [Assigned Date]@row, "0")

This is what I have, I want it to display the zero if there is no date in the assigned date column. I get invalid operation when there is not a date.

Thank you for your help.

Ali

KPH

Sorry, I copied and pasted your ending and left a parenthesis in there. Try this:

=IF(ISDATE([Assigned Date]@row), TODAY() - [Assigned Date]@row, 0)

KPH

Hi @AliT

You can use IF and ISDATE

=IF(ISDATE([Assigned Date]@row),TODAY() - [Assigned Date]@row),"0")

AliT

Maybe I am copying it wrong but I am getting #unparseable

KPH

Sorry, I copied and pasted your ending and left a parenthesis in there. Try this:

=IF(ISDATE([Assigned Date]@row), TODAY() - [Assigned Date]@row, 0)

Ric T

Neato, I got the same result using the ISBLANK formula:

=IF(ISBLANK([Assigned Date]@row), 0, [Assigned Date]@row - TODAY())

Cheers,

Ric

AliT

Thank you KPH!

That did it!!

KPH

Great @AliT

@Ric T 's ISBLANK will do a similar thing but when it comes to dates I prefer ISDATE as I don't trust anyone 😉 If you write text into a date column the ISBLANK will return an error message, while ISDATE will return the 0 as it knows the text is not a date. You could also use IFERROR to just remove all error messages entirely. There are pros and cons for each - your call!

Ric T

@KPH that's a great point, didn't think about it from that angle. Thanks for sharing!