Hello, I'm trying to return the date in a field based on the urgency selected in another field. For example, if the urgency is "As soon as possible" the date should return today's date which I'm able to get with TODAY() formula. However, I couldn't manage to get next week's date with TODAY() + 7 as I would do in Excel. What is the correct formula would be for that? Thank you!
Solved
Return next week's date relative to Today
+3Best answer by Ron_Williams
Hello. This should work:
IF(urgency="As soon as possible",TODAY(),DATEADD(TODAY(),7,'days'))
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.