Hi, I have a table of dates (including blanks) that I need to count the number of unique dates, excluding weekend dates.
Please see attached sheet for data and requirements.
Many thanks
John
Hi, I have a table of dates (including blanks) that I need to count the number of unique dates, excluding weekend dates.
Please see attached sheet for data and requirements.
Many thanks
John
It comes as 23
=SUM((FREQUENCY(IF(ISNUMBER(B3:J23),IF(WEEKDAY(B3:J23,2)<6,B3:J23)),ROW(INDIRECT(MIN(B3:J23)&":"&MAX(B3:J23))))>0)+0)
Try above Array Formula (Confirm with Shift+Ctrl+Enter)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thanks for the solution brilliant result exactly what i'm looking for.
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks