Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Date and Text as possible outcome

Topic Labels: Dates & Timezones
Solved
Jump to Solution
241 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey everyone,

Sorry if this has been asked before, I couldn’t find anything.
I am still a beginner.

My Problem is the following:

IF({Laufzeit (Monate)}= BLANK(),"", DATEADD(Vertragsbeginn,{Laufzeit (Monate)},“Month”))

It works, but the result it is no longer shown as a date. I guess because it could either be a date or a text, it doesn’t recognize it.
So what I want is to have an empty cell in case “Laufzeit (Monate)” ist empty and the calculated date as a date in case “Laufzeit (Monate)” is filled.
Could anyone help?

1 Solution

Accepted Solutions

Hi Carmen. All you need to do is to flip your logic in the IF.

IF({Laufzeit (Monate)}, DATEADD(Vertragsbeginn,{Laufzeit (Monate)},"Month"))

Give that a try!

See Solution in Thread

2 Replies 2

Hi Carmen. All you need to do is to flip your logic in the IF.

IF({Laufzeit (Monate)}, DATEADD(Vertragsbeginn,{Laufzeit (Monate)},"Month"))

Give that a try!

It works! Thank you so much!