Looking for some assistance on why my calculated column formula doesn't work when there is 5 weeks in the month.
I have one column called Current Patching Date (date/time field) - stores a date
I have one column called Next month calculated (calculated column) - this calculates the month following the date in the Current Patching Date column
I have one column called 3rd Tue-Next Month Patch Date (calculated column) - this should calculate the 3rd Tuesday in the month. I use the following formula for this column:
=DATE(YEAR([Next month calculated]),MONTH([Next month calculated]),(3-MOD(WEEKDAY(DATE(YEAR([Next month calculated]),MONTH([Next month calculated]),1)),7)+15))
This formula works fine if there is only 4 weeks in month, but doesn't work if there are 5 weeks in the month. Does anyone have any insight into why this would be? This is the only formula I have found searching the web that is remotely close to what I need to accomplish.