View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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
|