If you have start date in A2 and end date in B2 this should do it....
=SUMPRODUCT((DAY(ROW(INDIRECT(A2&":"&B2-1)))={1,2,3,4,5})+0)
If you have start date in A2 and end date in B2 this should do it....
=SUMPRODUCT((DAY(ROW(INDIRECT(A2&":"&B2-1)))={1,2,3,4,5})+0)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks