Calculate diff between dates not including weekends/holidays

[icsupt]

I need to calculate the difference between two dates not including weekends or holidays.

Is there a way to build a holiday table and have the formula subtract those holidays automatically?

Also, I tried NETWORKDAYS but that gives me the wrong answer. For example, if the date in A1 is 11/27/04 and the date in B1 is 11/27/04, it returns 1. I need it to return 0.

Thanks in advance.

 

[ETID]

This is a snipet from the "help" ...searched on on networkdays function

NETWORKDAYS


Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.

If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.

How?

Syntax

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.

 

[KenWright]

Note you can also use references to other cells that contains dates as your arguments, in this case it would be your A1 and B1.

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------