Skip to main content
Solved

Date and Text as possible outcome

  • August 10, 2021
  • 2 replies
  • 23 views
C

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?

Best answer by augmented

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!

    kuovonne

    2 replies

    A
    Forum|alt.badge.img+18
    • augmented
    • Inspiring
    • Answer
    • August 10, 2021

    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!

    kuovonne
    Justin_Barrett
    C
    • Carmen_Schick
    • Author
    • New Participant
    • August 17, 2021

    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!

    Terms & ConditionsAccessibility statement