Skip to main content

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

  • August 28, 2023
  • 1 reply
  • 30 views
C
Forum|alt.badge.img+2

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!

 

1 reply

Zack_S
Forum|alt.badge.img+17
  • Zack_S
  • Inspiring
  • 95 replies
  • August 28, 2023

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

 


Terms & ConditionsAccessibility statement