Return next week's date relative to Today

[ATOLYE_Global]

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! 

[Ron_Williams · Accepted solution]

Hello. This should work:

IF(urgency="As soon as possible",TODAY(),DATEADD(TODAY(),7,'days'))