LinkBack URL
About LinkBacks
Holiday Count: =SUM(--ISNUMBER(MATCH(Hol!G5:G6,(D4:AH4)*(D5:AH5),0)))
Weekday Count: =SUM((WEEKDAY(D$4:AH$4,2)<6)*(D5:AH5))
Weekend Count: =SUM((WEEKDAY(D$4:AH$4,2)>5)*(D5:AH5))
Holiday Count: =SUM(--ISNUMBER(MATCH(Hol!G5:G6,(D4:AH4)*(D5:AH5),0)))
Weekday Count: =SUM((WEEKDAY(D$4:AH$4,2)<6)*(D5:AH5))
Weekend Count: =SUM((WEEKDAY(D$4:AH$4,2)>5)*(D5:AH5))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks