Business Research Technology Microsoft Excel Tutorial – How to know the number/s of any day between two dates? January 17, 2023January 17, 2023 Usman Zafar Paracha 0 Comments business, days, Excel, microsoft, Research, technology, tutorialThis post contains formulae to know the number/s of any day between two dates in Microsoft Excel. Check more here on SayPeople.com Formulae to know the number/s of any day between two dates Rectangle.796 Formulae to know the number/s of any day between two dates Formulae to know the number/s of any day between two dates 2-D word balloon Assuming that the dates are mentioned in A1 and A2 Assuming that the dates are mentioned in A1 and A2 Rectangle.798 =SUMPRODUCT(–(TEXT(ROW(INDIRECT(A1&":"&A2)),"ddd")="Mon")) =SUMPRODUCT(–(TEXT(ROW(INDIRECT(A1&":"&A2)),"ddd")="Mon")) Dynamic connector.799 Dynamic connector.802 gives gives Dynamic connector.801 example example 2-D word balloon.834 “Mon” can be replaced with any other day “Mon” can be replaced with any other day Sheet.75 Sheet.76 Rectangle.836 =SUMPRODUCT(–(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=2)) =SUMPRODUCT(–(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=2)) Rectangle.837 =SUMPRODUCT(–(TEXT(ROW(INDIRECT(A1&":"&A2)),"ddd")="Mon")) =SUMPRODUCT(–(TEXT(ROW(INDIRECT(A1&":"&A2)),"ddd")="Mon")) Dynamic connector.841 Dynamic connector.842 Related
