Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working days left in a month.
I am trying to calculate the number of working days left in a month.
I have a sales goals spreadsheet that tells the seller how much they have to sell each day to meet their goal at the end of the month. In order to calculate that we need to know how many working days (Mon-fri minus holidays) are left in the month. I am probably doing this the long way, but I am trying to break it down into steps so that a rookie like me can get it done. A2 has the first day of the month, J2 has =EOMONTH(A2,0) to calculate the last day of that month. J6:J12 has all of our paid holidays listed. D2 lists the total workdays in a month with this formula: =NETWORKDAYS(A2,J2,J6:J12). Now that I have all of those dates lol I was trying to use WORKDAYS to get the number of working days left and cannot seem to get it to work. Basically I wanted to enter the 1st day of the month each month into A2 and have excel calculate the rest for me. Thanks for any help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountDays? need to count days in range by month | Excel Worksheet Functions | |||
Formula for Adding Time | Excel Discussion (Misc queries) | |||
Match Last day of this month to last day of last month | Excel Discussion (Misc queries) | |||
Calculate Days in a Month | Excel Discussion (Misc queries) | |||
amount of working days per month | Excel Discussion (Misc queries) |