Help

Date and Text as possible outcome

Topic Labels: Dates & Timezones
Solved
Jump to Solution
895 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Carmen_Schick
4 - Data Explorer
4 - Data Explorer

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
augmented
10 - Mercury
10 - Mercury

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
augmented
10 - Mercury
10 - Mercury

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!