Date formula: Return a blank if a cell has no date

jyoung_autosoftdms

I have a date formula =NETDAYS([DUO Link Sent]@row, TODAY(1))

If the DUO Link Sent cell is empty it's returning #INVALID DATA. How do I get this formula to return a blank cell if the DUO Link Set does not have a date in it yet.

Jeff Reisman

@jyoung_autosoftdms

Two methods:

Wrap your formula in IFERROR. This suppresses any error messages and replaces them with whatever you want, For your example, replace the error message with blankness:

=IFERROR(NETDAYS([DUO Link Sent]@row, TODAY(1)), "")

Alternatively, you can use an IF statement that runs the formula if DUO Link Sent on that row contains a date value, but does something else if it's not a date value:

=IF(ISDATE([DUO Link Sent]@row, NETDAYS([DUO Link Sent]@row, TODAY(1)), NETDAYS(CreatedDate@row, TODAY(1)))

Jeff Reisman

@jyoung_autosoftdms

Two methods:

Wrap your formula in IFERROR. This suppresses any error messages and replaces them with whatever you want, For your example, replace the error message with blankness:

=IFERROR(NETDAYS([DUO Link Sent]@row, TODAY(1)), "")

Alternatively, you can use an IF statement that runs the formula if DUO Link Sent on that row contains a date value, but does something else if it's not a date value:

=IF(ISDATE([DUO Link Sent]@row, NETDAYS([DUO Link Sent]@row, TODAY(1)), NETDAYS(CreatedDate@row, TODAY(1)))

jyoung_autosoftdms

This is great, thank you so much for the quick response. Someday I hope I can share with others and return the favor.