Formula for First Tuesday of the Previous Month

Hello ​@kuovonne thank you for the explanation, the longer write up was greatly appreciated and solved my problem.

This is what I utilized in the end.

Date Field labelled {Date}

First of Previous Month (Field Name)

DATEADD(
  DATEADD(
    {Date},
    -1 * (DAY({Date}) - 1),
    "days"
  ),
  -1,
  "month"
)

This output the 1st of the month prior

Then I added another field to find the 1st Tuesday.

First Tuesday of Previous Month (Field Name)

SWITCH( WEEKDAY({First of Previous Month}, "Sunday"),
0, DATEADD({First of Previous Month}, 2, 'days'),
1, DATEADD({First of Previous Month}, 1, 'days'),
2, DATEADD({First of Previous Month}, 0, 'days'),
3, DATEADD({First of Previous Month}, 6, 'days'),
4, DATEADD({First of Previous Month}, 5, 'days'),
5, DATEADD({First of Previous Month}, 4, 'days'),
6, DATEADD({First of Previous Month}, 3, 'days')
)

This outputted the first Tuesday of the previous month.

Thanks again!

You can start with the first day of the previous month and find the next Tuesday. In Excel or SQL, a combination of WEEKDAY() and DATEADD() should help Visit Auslandei. Have you tried adjusting based on the weekday value.