Subtracting dates - if error than string

Shlomi · 08/18/22

Hi all,

I want to substruct between 2 dates. but if there is a String, I want to write The following: "~"

Help me pls :)

Hollie Green · 08/18/22

If I'm understanding correctly and your formula is working the way you want it to in your other rows. It should be

=iferror([End date]@row-[Start date]@row+"Days","~")

Hollie Green · 08/18/22

If I'm understanding correctly and your formula is working the way you want it to in your other rows. It should be

=iferror([End date]@row-[Start date]@row+"Days","~")

Shlomi · 08/18/22

Yes, it is working.

another thing, maybe you can help me

I want to add the following to the function above:

If the string is "Days" then write "Nothing"

Best Answer