Transform amount of days into > or < 3 months

[Flappy8Flapjack]

Hi all,

I have a problem and I cannot figure it out on my own.

I need to transform the amount of days into [TEXT] '< 3 months' (<90 days) or [TEXT] '> 3 months' (>89 days). The transform options do not give a solution, or i cannot find it. Please help me out. I think there must be a simple solution :).

Thanks in advance!

[Tahreem24]

@Flappy8Flapjack, It would be better if you share sample data along with expected output in excel format.

[Bifinity_75 · Accepted solution]

Hi @Flappy8Flapjack , you can create a calculate column:

Result = SWITCH(TRUE(),
        'Your column Amount of days'<90, "<3 months",
        'Your column Amount of days'>89, ">3 months",
        ""
        )

I hope works for you, Best regards