Help

Return next week's date relative to Today

Topic Labels: Formulas
Solved
Jump to Solution
1209 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ATOLYE_Global
4 - Data Explorer
4 - Data Explorer

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! 

1 Solution

Accepted Solutions
Ron_Williams
6 - Interface Innovator
6 - Interface Innovator
Hello. This should work:
IF(urgency="As soon as possible",TODAY(),DATEADD(TODAY(),7,'days'))

 

See Solution in Thread

1 Reply 1
Ron_Williams
6 - Interface Innovator
6 - Interface Innovator
Hello. This should work:
IF(urgency="As soon as possible",TODAY(),DATEADD(TODAY(),7,'days'))