| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Excel Worksheet Functions | |||
| Count number of cells of a particular month in a column of dates | Excel Discussion (Misc queries) | |||
| count by month | Excel Worksheet Functions | |||
| Count Mondays worked in Month | Excel Worksheet Functions | |||
| Count number of items by month | Excel Worksheet Functions | |||
Linear Mode
