Weekday formula calculating to end of month

D

DebbieK

I have a timesheet that I have set the formula to calculate the date
and days excluding weekends for a given month. How do I set th
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weekday formulas calculating to end of month 1
Use array/braces **WITHIN** a formula? 6
Search closest day in the past from today 2
Percentage of month passed formula 1
Formula to get number of days excluding Fridays in a given period 17
Unexpected result from IF statement... Help with formula. 3
Conditional Arrays 1
1st Wed, 1st Sat, 1st Sun 5

Top