Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forward planning (networkdays without last 2 parameters)
I am building a forward schedule from (time) values generated by the spread
sheet I have a calendar control on the page, and I click on to my anticipated starting date This value is loaded into a cell Next cell down references this (calender1.value) and adds the day/s (generated by the spreadsheet) i.e Thursday 26 may 2005 add 4.5 days But I dont want to include the week-end as working days How do I calculate the next cell to show Wednesday 1 June 2005? jumping over the week-end I do not have a end date as this function Starts on a date and ends when all the values are used -- Graeme |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forward planning (networkdays without last 2 parameters)
Use the Workdays worksheet function (found in the analysis toolpak). If it
isn't available, you need to select the Analysis Tookpak in Tools=Addins. -- Regards, Tom Ogilvy "Graeme" wrote in message ... I am building a forward schedule from (time) values generated by the spread sheet I have a calendar control on the page, and I click on to my anticipated starting date This value is loaded into a cell Next cell down references this (calender1.value) and adds the day/s (generated by the spreadsheet) i.e Thursday 26 may 2005 add 4.5 days But I dont want to include the week-end as working days How do I calculate the next cell to show Wednesday 1 June 2005? jumping over the week-end I do not have a end date as this function Starts on a date and ends when all the values are used -- Graeme |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
brought forward & carried forward | Excel Worksheet Functions | |||
Help with program planning | Excel Discussion (Misc queries) | |||
financial planning | Excel Discussion (Misc queries) | |||
Material Requirements Planning-MRP/Capacity Requirements Planning- | Excel Discussion (Misc queries) | |||
Planning reports | Excel Discussion (Misc queries) |