Formula for calculating EOM when Saturday is a workday

[UFGATORS]

Hello, I have a facility where their workweek is Monday through Saturday an I need to be able to determine which day of the month will be the last workday, EOM. I'm currently using this formal for a normal 5-day workweek "=IF(WORKDAY(EOMONTH($L$2,0)+1,-1,holidays)=AJ2,"EOM","")". I did some reading and it looks like I need to use the WORKDAY.INTL function but I can't figure it out. Starting at AJ1:AP1 the above formula is entered, the dates are on line two L2:AP2. I need for the EOM to appear on the last work day of the month with Saturday being the last day of the workweek. Thanks for the help.

 

[JonXL]

=EOMONTH(TODAY(),0)-(7-WEEKDAY(EOMONTH(TODAY(),0),2))

Replace TODAY() with the date in the month you want to check.

Oooo.... I see you can't include Sunday.

Try this:

=IF(WEEKDAY(EOMONTH(TODAY(),0),2)=7,EOMONTH(TODAY(),0)-1,EOMONTH(TODAY(),0))

 

[Tetra201]

Is this what you need?

=IF(WORKDAY.INTL(EOMONTH($L$2,0)+1,-1,11,Holidays)=AJ2,"EOM","")