| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dates: no weekends and no hollidays
a have a formula that returns a date. now id like to check the date
whether its a weekday or a holliday and if it is -than to return the first workday after... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dates: no weekends and no hollidays
Look at the WORKDAY() function.
If not available: ToolsAdd-ins, check Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "Mortir" wrote in message ... |a have a formula that returns a date. now id like to check the date | whether its a weekday or a holliday and if it is -than to return the | first workday after... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dates: no weekends and no hollidays
On Thu, 6 Dec 2007 02:04:27 -0800 (PST), Mortir wrote:
a have a formula that returns a date. now id like to check the date whether its a weekday or a holliday and if it is -than to return the first workday after... =WORKDAY(your_formula-1,1,[holidays]) [holidays] is a range where you have listed all the holiday dates during the time frame of interest. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate number of WEEKENDS between two dates? | Excel Discussion (Misc queries) | |||
| Charting dates on the Y axis without weekends | Charts and Charting in Excel | |||
| get hours between 2 dates subtracting the weekends | Excel Discussion (Misc queries) | |||
| How do I eliminate non-used dates (weekends) from a chart? | Charts and Charting in Excel | |||
| How to Calculate Dates without counting the weekends | Excel Worksheet Functions | |||
Linear Mode
