A formula that finds the first wednesday after the 10th of the month

[plyske]

Hello! 

Can someone help me create a formula that finds the first wednesday after the 10th of the month? 

I have 1 date field that I manually give a date value (eg. 1/4/23), and then I have a formula field that should find the first wednesday after the 10th of the month. 

Is that possible?

[joshsorenson]

Try this out 🙂 

DATETIME_PARSE(
IF(DATEADD(DATETIME_PARSE(DATETIME_FORMAT({Date Field},'YYYY-MM')&'-10'), 2, 'days')>DATETIME_PARSE({Date Field}),
DATETIME_FORMAT(DATEADD(DATETIME_PARSE(DATETIME_FORMAT({Date Field},'YYYY-MM')&'-10'), 2, 'days'), 'M/DD/YYYY'),
DATETIME_FORMAT(DATEADD(DATETIME_PARSE(DATETIME_FORMAT({Date Field},'YYYY-MM')&'-10'), 9, 'days'), 'M/DD/YYYY')
)