Fred,
Thanks for the information, does this take into consideration that my fields
store both the date and time into 1 cell? I thought it was tricker than what
you show below.

Thanks,

"Fred Smith" wrote:

You want Networkdays, as in:
=networkdays(b2,q2)
or,
=networkdays(q2,b2)
depending on how your data is stored.

If you want to take holidays into account, create a list of them, and feed
them into the function, as in:
=networkdays(q2,b2,a1:a10)

Regards,
Fred


"Diane" wrote in message
...
I have two date & time fields that I need to calcualte the number of days
line is open. I have my first data point in B2 and the one to subtract is
in
Q2.

Thanks,

.