Subtracting dates - if error than string

Shlomi

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

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

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

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"