Text Returned based on a Date Coloum

JO H

Hi

I don't know if I am just unable to find the right question to ask in a search but I cant seem to find the right answer.

I have Text Column called "Health" and a date column called "Date Requested" which I write the date the task came in.

What I would like to do is:

If the "Date Requested" is 7 days in the past I want the Health to say "1 Week"

If the "Date Requested" is 14 days in the past I want the Health to say "2 Weeks"

If the "Date Requested" is 28 days in the past I want the Health to say "4 Weeks"

I tried the IF function and various solutions on here but they all use TODAY and I don't want it from Today, I want it from the "date Requested"

Thank you

JO H

Actually, I think I have just worked it out

=IF(TODAY() > [Date Requested]@row + 28, "4 Weeks", IF(TODAY() > [Date Requested]@row + 14, "2 Weeks", IF(TODAY() > [Date Requested]@row + 7, "1 Week")))

Hope this is ok

Genevieve P.

Hey @JO H

Well done! I'm glad you were able to figure this out.

Cheers,

Genevieve