LinkBack URL
About LinkBacks
Missed Day count
=(B2-A2+1)-COUNT(C3:C120)
=185
Missing dates
in D3
IFERROR(SMALL(IF(COUNTIF($C$3:$C$121,ROW($42005:$42307))=0,ROW($42005:$42307),""),ROWS($1:1)),"")
Enter with Ctrl+Shift+Enter
42005= 1st jan 2015 (in Excel date)
42307= 30th October
Missed Day count
=(B2-A2+1)-COUNT(C3:C120)
=185
Missing dates
in D3
IFERROR(SMALL(IF(COUNTIF($C$3:$C$121,ROW($42005:$42307))=0,ROW($42005:$42307),""),ROWS($1:1)),"")
Enter with Ctrl+Shift+Enter
42005= 1st jan 2015 (in Excel date)
42307= 30th October
Dear John
the formula in D column list all the day include non-work day
what about if i need only show working day and exclude nonworking day from this missed date list and holiday also from list
Last edited by mazan2010; 01-24-2017 at 02:13 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks