How can calculate how many working days there are left in the current month.

[Romano_odK]

Good afternoon,

Now I know what the formula is for calculating how many working days there are in the current month. What I now need to know is how many working days there are left in the current month. How can achieve this?

Thank you for your time.

Romano

=NETWORKDAYS(TODAY();EOMONTH(TODAY();0))

 

[Fluff]

That's what you formula already does.

 

[Romano_odK]

That's what you formula already does.

Oh really I thought, didn't check it that it were the total amount of working days. Ok then I need to the total working days.

 

[James006]

Total working days in Current Month :

=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(TODAY()),1),EOMONTH(TODAY(),0))

 

[Fluff]

Ok, how about

=NETWORKDAYS(EOMONTH(TODAY();-1)+1;EOMONTH(TODAY();0))

 

[Romano_odK]

Ok, how about

=NETWORKDAYS(EOMONTH(TODAY();-1)+1;EOMONTH(TODAY();0))

Perfect! Thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.