Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use modified calendar in excel calculations
I wish to plan dates when certain actions in a project are due for
completion. Project is not suitable for my needs as i am creating a spreadsheet with several types of information. The problem is that i wish to either modify the calendar used in excel so as to exclude weekend days, bank holidays and several days over the christmas period and do not know how to do this. Alternativly I could create a new data type much like the one uesd for caluclating dates in excel where a value is attributed to each date and unnecessary days could just be skipped and not given a value. Anyone know how i could implement either of these approaches? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use modified calendar in excel calculations
Don't create your own date data type; you'll get yourself into trouble. Use the built-in one.
You can use the WORKDAY() and NETWORKDAYS() functions to exclude weekends, holidays etc. Look in HELP for details. If you don't have these functions available: ToolsAdd-ins, check Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "briancarroll101" wrote in message ... |I wish to plan dates when certain actions in a project are due for | completion. Project is not suitable for my needs as i am creating a | spreadsheet with several types of information. The problem is that i wish to | either modify the calendar used in excel so as to exclude weekend days, bank | holidays and several days over the christmas period and do not know how to do | this. Alternativly I could create a new data type much like the one uesd for | caluclating dates in excel where a value is attributed to each date and | unnecessary days could just be skipped and not given a value. | Anyone know how i could implement either of these approaches? | Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculations run slow in Excel 2002 SP-1 | Excel Discussion (Misc queries) | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Export/link a course schedule from excel into calendar format | Excel Discussion (Misc queries) | |||
Erasing Outlook Calendar from within Excel | Excel Discussion (Misc queries) |