Count workdays remaining in a month
 

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...o&userid=37372
View this thread: http://www.excelforum.com/showthread...hreadid=570631

Count workdays remaining in a month
 

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

If you get a #NAME error: ToolsAdd-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ads" wrote in message ...
|
| 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...o&userid=37372
| View this thread: http://www.excelforum.com/showthread...hreadid=570631
|

Count workdays remaining in a month
 

Thanks Niek, Tat works brilliantly.


--
Ads
------------------------------------------------------------------------
Ads's Profile: http://www.excelforum.com/member.php...o&userid=37372
View this thread: http://www.excelforum.com/showthread...hreadid=570631