holiday calendar
Posted by mike on February 14, 2001 4:18 AM
is it possible to get from somewhere or to set up a business calendar
in excel, which can be used as a reference for certain future schedules
(e.g. payments in the future,...), so that, when looking up a date, the
spreadsheet figures out, if it is a non-business day and if, to look up
the next valid date ?
Posted by Mark W. on February 14, 2001 7:05 AM
Mike, did you look at the list of date functions
provided by Excel's help facility? The WORKDAY()
function might do the trick.
Posted by mike on February 14, 2001 10:49 AM
too simple ! take for example the 18th of February 2008, a Monday, but an american holiday (president's day), excel would not know that!unless you put that kind of data into excel manually, so the workday() function does not work.
Posted by Mark W. on February 14, 2001 2:14 PM
So, I take it that you didn't look at the
online documentation for WORKDAY().
WORKDAY(start_date,days,holidays)
Holidays is an optional list of one or more dates
to exclude from the working calendar, such as
state and federal holidays and floating holidays. The list can be either a range of cells or an array constant of the numbers that represent the dates.
Posted by mike on February 15, 2001 3:49 AM
you are right, i did not know that. thanks very much ! much appreciated !!!
mike.
