Dynamic date formula

[jamiemburns]

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')

[TheTimeSavingCo]

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

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

[jamiemburns · Accepted solution]

Thank you!