=WORKDAY(EOMONTH(report_date,-1),-1, holidays) YIELDS .. "APRIL 28, 2023" because the report_date is 5/1/2023
but if i apply that same formula for 2 month ago
=WORKDAY(EOMONTH(report_date,-2),-1, holidays) , im getting "March 30,2023," but I want March 31, 2023
what am i doing wrong here?
if i change it to "=WORKDAY(EOMONTH(report_date,-2),0, holidays)", then I get "March 31, 2023" , but obviously changing the formula depending on the month is not the ideal solution
but if i apply that same formula for 2 month ago
=WORKDAY(EOMONTH(report_date,-2),-1, holidays) , im getting "March 30,2023," but I want March 31, 2023
what am i doing wrong here?
if i change it to "=WORKDAY(EOMONTH(report_date,-2),0, holidays)", then I get "March 31, 2023" , but obviously changing the formula depending on the month is not the ideal solution