What happened when you tried it?

In answer to your question, Networkdays ignores the time portion of the
cell.

Regards,
Fred

"Diane" wrote in message
...
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,

.