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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working days left in a month.
LOL, all I had to do was type it out and i figured it out...
=NETWORKDAYS(H2,J2,J7:J12) If anyone knows a simpler way I would be interested. Thanks! On Jan 28, 1:49 pm, wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working days left in a month.
Just use TODAY() as the first argument in the NETWORKDAYS function:
=NETWORKDAYS(TODAY(),J2,J6:J12) Biff wrote in message oups.com... 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working days left in a month.
Works perfect, thanks again Biff! On Jan 28, 2:13 pm, "T. Valko" wrote: Just use TODAY() as the first argument in the NETWORKDAYS function: =NETWORKDAYS(TODAY(),J2,J6:J12) Biff wrote in ooglegroups.com... 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!- Hide quoted text -- Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working days left in a month.
You're welcome!
Biff wrote in message oups.com... Works perfect, thanks again Biff! On Jan 28, 2:13 pm, "T. Valko" wrote: Just use TODAY() as the first argument in the NETWORKDAYS function: =NETWORKDAYS(TODAY(),J2,J6:J12) Biff wrote in ooglegroups.com... 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!- Hide quoted text -- Show quoted text - |
Reply |
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) |