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... |
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... |
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 |
All times are GMT +1. The time now is 02:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com