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?
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()
)))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()
)))
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()
)))
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()
)))
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()
)))
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'),
)
)
)
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'),
)
)
)
That still did not work, what am I missing
That still did not work, what am I missing
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?
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')
)
)
)
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')
)
)
)
You are a genius THANK YOU!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.