Formula that calculates x days from today (but x changes), and results in a date

[CorieSmiga]

Hi there,

I am hoping there is a formula for what I need. I want to be able to have a date populate when I put in 30 days from today, or 20 days, or 45 days.

Example: I need to follow up with sales lead A 30 days from today. What is that date?

Thank you!

[Zack_S]

Hi @CorieSmiga - You will want to use the DATEADD() function. See the example below.