Help

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

Topic Labels: Formulas
653 1
cancel
Showing results for 
Search instead for 
Did you mean: 
plyske
7 - App Architect
7 - App Architect

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?

1 Reply 1
joshsorenson
6 - Interface Innovator
6 - Interface Innovator

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