Hello... I hoping someone can help me. I need a formula to calculate the difference between 2 dates excluding wkends. However, if a wkend is entered into to the start or end time, I would like the forumula to automatically start calculating fm Monday.
I am currently using NETWORKDAYS(D2,E2,AZ2:BC2)-1-MOD(D2,1)+MOD(E2,1))... when a wkend date is entered the result is ####
Thanks!
Bookmarks