Calculating "working days" vs "calendar days"

[Rich]

I want to calculate the number of "working" days between
given dates, but exclude certain days (Saturdays, Sundays,
and holidays). Haven't a clue how to work with the date
functions - the few times I've tried they just haven't
made sense. So if you have an answer, please go step by
step. Thanks.

[dave]

check out the NETWORKDAYS function in the help menu. from what you say,
that is exactly what you need. you will need to make sure you have the
analysis toolpak add-in

-dave

"Rich" <RNe...@sizeler.com> wrote in message
news:00dc01c2f7bd$a79848d0$a401...@phx.gbl...

[Wilson]

Check this out in Help, Rich
NETWORKDAYS(start_date,end_date,holidays)

Start_date is a date that represents the start date. Dates may be entered
as text strings within quotation marks (for example, "1/30/1998" or
"1998/01/30"), as serial numbers (for example, 35825, which represents
January 30, 1998, if you're using the 1900 date system), or as results of
other formulas or functions (for example, DATEVALUE("1/30/1998")).

End_date is a date that represents the end date.

Holidays is an optional range 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 that contain the dates or an array
constant of the serial numbers that represent the dates. Learn about array
constants. For more information about how Microsoft Excel uses serial
numbers for dates, see the Remarks section.

HTH

"Rich" <RNe...@sizeler.com> wrote in message
news:00dc01c2f7bd$a79848d0$a401...@phx.gbl...

[Mark Graesser]

Look at the NETWORKDAYS function, This will ignore weekends and designated
holidays.

=NETWORKDAYS(A2,A1,C1:C3)

A2-start date
A1-end date
C1:C3 - designated holidays

Good Luck,
Mark Graesser

"Rich" <RNe...@sizeler.com> wrote in message
news:00dc01c2f7bd$a79848d0$a401...@phx.gbl...