Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =SUM(IF(AND((WEEKDAY([Return Date],2))<(WEEKDAY([Start Date],2)),((WEEKDAY([Start Date],2))-(WEEKDAY([Return Date],2)))>1),(((DATEDIF([Start Date],[Return Date],"D")))-(FLOOR((DATEDIF([Start Date],[Return Date],"D"))/7,1)*2)-2),(((DATEDIF([Start Date],[Return Date],"D")))-(FLOOR((DATEDIF([Start Date],[Return Date],"D"))/7,1)*2))),1)*1-1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
