Hi there!
We are looking to have a "launch date" formula field based on the merge field ( CloseDate ). If the ( CloseDate ) is the 1st-15th of the month then the launch date would be the third Wednesday of that month but if the ( CloseDate ) is the 16th-31st of the month then the launch date would be the second Wednesday of the following month. I am struggling with how I would accomplish that and would appreciate advice!
So basically something like this?
IF(
DAY( CloseDate ) <= 15,
DATE(YEAR(CloseDate),MONTH(CloseDate), 01) +
CASE(WEEKDAY(DATE(YEAR(CloseDate),MONTH(CloseDate), 01)),
1, 17,
2, 16,
3, 15,
4, 14,
5, 20,
6, 19,
7, 18,
0 ),
ADDMONTHS(DATE(YEAR(CloseDate),MONTH(CloseDate), 01), 1) +
CASE(WEEKDAY(ADDMONTHS(DATE(YEAR(CloseDate),MONTH(CloseDate), 01), 1)),
1, 10,
2, 9,
3, 8,
4, 7,
5, 13,
6, 12,
7, 11,
0 )
)
