# of business days between timestamp & another date

Hi,

I have an exported excel sheet from a google form. Column A on my document is a timestamp (mm/dd/yy hh:mm) and column I is another date (mm/dd/yy), a few days in the future. How do I get column O to count the # of business days between Column A & I?

Thank you!

Try the NETWORKDAYS function..

=NETWORKDAYS(A2,I2,$M$2:$M$20)

M2:M20 is an optional range of Holiday dates you can create to exclude from the count as well.