Weekday formulas calculating to end of month

[DebbieK]

I have a timesheet that I have set the formula to calculate the dates
and days excluding weekends. 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!

 

[Og]

I have a timesheet that I have set the formula to calculate the dates
and days excluding weekends. 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!

You may wish to post your query to one of these Excel specific newsgroups:
microsoft.public.excel.programming
microsoft.public.excel.worksheet.functions
Steve