Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
My data is:
First Date 3/9/05 Last Date 5/12/05 Month Workdays* February-05 March-05 April-05 May-05 June-05 July-05 August-05 I need to calculate the number of avialble work days per month, but I also need to have the formula adjust to account for the start and end dates. In the above example is there a formula to calculate: March-05 (Number of weekdays in March (subtracting the week days excluded by the start date) April-05 (Number of weekdays in April) May-05 (Number of weekdays in May (subtracting the weekdays excluded by the end date) I don't know how to creat the proper IF statement or weekday formula. Please Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Character Count Range of Cells | Excel Discussion (Misc queries) | |||
user defined function | Excel Worksheet Functions | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
How do I count data in range A:A that is dependent upon criteria . | Excel Worksheet Functions | |||
Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions |