IFTT formula help

[Leslie_Miller]

I want to formulate a date if:
under one column the answer is 3-day add 3 days to date
under one column the answer is 2- day add 2 days to date
under one column the answer is 1- day add 1 day to date

I think I begin like this, DATEADD({Proposed Date of W/C},3, ‘days’)

but how do I formulate the if this then that?

[Eric_Petersen]

IF(
 SEARCH("1", {Day Course}),
  DATEADD(Date, 1, 'days'),
IF(
 SEARCH("2", {Day Course}),
  DATEADD(Date, 2, 'days'),
IF(
 SEARCH("3", {Day Course}),
  DATEADD(Date, 3, 'days'),
BLANK()
)))

[Leslie_Miller]

Eric_Petersen:

IF( SEARCH(“1”, {Day Course}), DATEADD(Date, 1, ‘days’), IF( SEARCH(“2”, {Day Course}), DATEADD(Date, 2, ‘days’), IF( SEARCH(“3”, {Day Course}), DATEADD(Date, 3, ‘days’), BLANK() )))

Thanks so much for your response.
not quite right yet, trying different scenarios, I think this might be close
IF(
SEARCH(“1”, {Type of Workshop or Class Offered}}),
DATEADD(Date, 1, ‘days’),
IF(
SEARCH(“2”, {Type of Workshop or Class Offered}),
DATEADD(Date, 2, ‘days’),
IF(
SEARCH(“3”, {Type of Workshop or Class Offered}{Day Course}),
DATEADD(Date, 3, ‘days’),
BLANK()
)))

[Leslie_Miller]

Tried this, still no luck

IF(
SEARCH(“1”, {Type of Workshop or Class Offered}}),
DATEADD {Proposed Date of Workshop or Class} 1, ‘days’),
IF(
SEARCH(“2”, {Type of Workshop or Class Offered}),
DATEADD {Proposed Date of Workshop or Class} 2, ‘days’),
IF(
SEARCH(“3”, {Type of Workshop or Class Offered}),
DATEADD {Proposed Date of Workshop or Class} 3, ‘days’),
BLANK()
)))

[Jeremy_Oglesby]

IF(
  SEARCH("1", {Type of Workshop or Class Offered}),
  DATEADD({Proposed Date of Workshop or Class}, 1, 'days'),
  IF(
    SEARCH("2", {Type of Workshop or Class Offered}),
    DATEADD({Proposed Date of Workshop or Class}, 2, 'days'),
    IF(
      SEARCH("3", {Type of Workshop or Class Offered}),
      DATEADD({Proposed Date of Workshop or Class}, 3, 'days'),
    )
  )
)

[Leslie_Miller]

That still did not work, what am I missing

[Jeremy_Oglesby]

How did it fail? Are you getting an error message in the formula editor? Is it just not returning what you expected? What is the nature of the failure?

[Leslie_Miller]

[Jeremy_Oglesby · Accepted solution]

Thanks, @Leslie_Miller - that was my bad. I left an erroneous comma in there. Try this:

IF(
  SEARCH("1", {Type of Workshop or Class Offered}),
  DATEADD({Proposed Date of Workshop or Class}, 1, 'days'),
  IF(
    SEARCH("2", {Type of Workshop or Class Offered}),
    DATEADD({Proposed Date of Workshop or Class}, 2, 'days'),
    IF(
      SEARCH("3", {Type of Workshop or Class Offered}),
      DATEADD({Proposed Date of Workshop or Class}, 3, 'days')
    )
  )
)

[Leslie_Miller]

You are a genius THANK YOU!!!