Count workdays remaining in a month

A

Ads

Hi,

I am trying to find a way to count the number of remainin
weekdays/working days in a month for budgeting.
ie today being the 11/08/06 i would expect to get a result of '1
including today or 14 not including today' days ramaining in the month
either way is permissable.

Any help would be appreciated
 
N

Niek Otten

=NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0))

If you get a #NAME error: Tools>Add-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Hi,
|
| I am trying to find a way to count the number of remaining
| weekdays/working days in a month for budgeting.
| ie today being the 11/08/06 i would expect to get a result of '15
| including today or 14 not including today' days ramaining in the month.
| either way is permissable.
|
| Any help would be appreciated.
|
|
| --
| Ads
| ------------------------------------------------------------------------
| Ads's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37372
| View this thread: http://www.excelforum.com/showthread.php?threadid=570631
|
 
Top