IF Functions with only Business Dates

  • Thread starter Thread starter Miranda
  • Start date Start date
M

Miranda

Hello everyone,

I'm trying to create an IF function that will subtract one
date and time from another but must be less than another
time (different column). I will have the answer be "Yes"
and "No". I can enter the formula up to this point, but
am not sure how to calculate only certain days.

I would like to have the formula only calculate business
days.

M-F, 8 -5

Is this possible?

Thanks for any help with this...

Miranda
 
Look into using the NETWORKDAYS function. You will need to install the Analysis Tool Pack, under Tools>Add-Ins

Good Luck
Mark Graesser
 
Back
Top