Francis,
I am trying to calculate the difference between two fields (data & time
combine in one cell). I need it to take into consideration only business
days as well.

Hope this makes more sense.

Thanks,


"Francis" wrote:

Diane

apology but I don't understand your requirement.....
--
Hope this help

Please click the Yes button below if this post have helped answer your needs

Thank You

cheers, francis





"Diane" wrote:

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,