Cell A1 that contains a date the user enters manually.
Cell A2 needs to contain the date for the previous work day from the date entered into cell A1.
Cell A3 needs to contain the number of work days that have passed from the first work day of the month thru the date in cell A2.
Cell A4 needs to contain the total number of work days in a specific month.
Our work days are Monday thru Saturday.
So for the month of March, cell A4 would have the number 27.
If 3/5/07 is entered in cell A1, cell A2 would have 3/3/07, and cell A3 would have the number 3.
If 3/8/07 is entered in cell A1, cell A2 would have 3/7/07, and cell A3 would have the number 6.
Do I need another cell that contains the month and year so the formula in cell A4 knows which month to count the working days for or could it reference the date in cell A2 to know which month and year to use?
Thanks in advance for your time.
- If you've never made a mistake, you've never made anything.
I can't think of a way to do this without VB, either. Take a look here http://www.dbforums.com/showthread.php?t=1605962
I posted some code in there that does just what your looking for.
You'll just have to make some changes for a six day week, and adapt it
to put the data into your cells.