Working days left in a month.

D

Doc203

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!
 
D

Doc203

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!
 
T

T. Valko

Just use TODAY() as the first argument in the NETWORKDAYS function:

=NETWORKDAYS(TODAY(),J2,J6:J12)

Biff
 

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

Excel Message box with days of month & date. 1
First working day of the month 2
Working days left in the month compared to previous months 8
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Calculate Number of Days worked in Each Month by Project 2
weekdays not using NETWORKDAYS 6
Multi NetWorkDays Calculation 3
Calculate days in each month 7

Top