LinkBack URL
About LinkBacks
Try
=AND(NETWORKDAYS(B4,F4)<=7,MOD(B4,1)>=MOD(F4,1))
Checks that the difference is less than 7 working days, and that the time in F4 is earlier than the time in B4.
Try
=AND(NETWORKDAYS(B4,F4)<=7,MOD(B4,1)>=MOD(F4,1))
Checks that the difference is less than 7 working days, and that the time in F4 is earlier than the time in B4.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks