Weekday formula calculating to end of month
 

I have a timesheet that I have set the formula to calculate the dates
and days excluding weekends for a given month. How do I set the
formula to stop on the last day of the month?

My current formula for the first cell (H6) is as follows:
=IF(WEEKDAY(AB2-1)<=5,AB2,AB2+8-WEEKDAY(AB2-1))
Note - cell AB2 is the entry for the first workday of the month

My current formula is as follows for the cells thereafter:
=IF(WEEKDAY(H6-1)<5,H6+1,H6+3)


Thanks for any assistance!




--
DebbieK