Skip to main content
Solved

Formula between dates

  • April 12, 2024
  • 2 replies
  • 16 views

Forum|alt.badge.img+4

Hello - 

I have a date column of when an event will occur (Showcase Date) & I am wanting a formula to populate deadlines based on number of days before or after this date. Here is the formula I created but it is not working. Any suggestions? 

I have tried: 

DATETIME_FORMAT(DATEADD({Showcase Date},{Number of days},'days),'MM/DD/YY')

Best answer by jamiemburns

Thank you! 

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

You're missing a ' after "days"; try:

DATETIME_FORMAT( DATEADD( {Showcase Date}, {Number of days}, 'days' ), 'MM/DD/YY' )

Forum|alt.badge.img+4
  • Author
  • New Participant
  • Answer
  • April 15, 2024

Thank you!