How to calculate a response time of 1 to 5 days

[Peggy]

I am currently using the formula provided in Excel help
which allows me to calculate the number of working days
(NETWORKDAYS) between two dates (Date Received and Date
Due).

Now I need to have my spreadsheet show only the dates
(between Date Received and Date due) that have a response
time of 1 to 5 days.

I'm not sure how to have my spreadsheet calculate this.
Can someone help?


Thanks,
Peggy

 

[Andy B]

Hi

You could use an IF function:
=IF(AND(NETWORKDAYS(Start,End,Holidays)>=1,
NETWORKDAYS(Start,End,Holidays)<=5),NETWORKDAYS(Start,End,Holidays),"")
Or you could use Format / Conditional Formatting, with the Cell Is box not
being between 1 and 5, and set your font to white

Hope this helps.