Workdays formula

Hi all,

I'm having some trouble to find a way to get this working.

Objective: Determinate if a message received is IN or OUT SLA.
Observations: Messages are only answered on workdays. Weekends can't count for SLA.
Difficulty: Remove the "-1" form the automatic formula if the message is received during weekend.


Currently I have this formula configured to define an SLA of 1 day, considering "Start Date" and "End Date":

=NETWORKDAYS(F5;L5)-1

It's working correctly for week days, if I receive a message on Monday, I have until Tuesday to reply.


Thanks!

without knowing more in terms of nuances etc, perhaps:

=NETWORDAYS(F5;L5)-(WEEKDAY(F5;2)<6)

Originally Posted by XLent

without knowing more in terms of nuances etc, perhaps:

=NETWORDAYS(F5;L5)-(WEEKDAY(F5;2)<6)

Working! Thanks a lot XLent!