SayPeople

Starting from science and ending nowhere…

Business Research Style Technology 

Microsoft Excel Tutorial – How to know the number/s of Friday the 13th between two dates?

Usman Zafar Paracha 0 Comments , , , , ,
Microsoft Excel Tutorial

This post contains formula to know the number/s of Friday the 13th between two dates. Check more here on SayPeople.com

Formula to know the number of Friday the 13th between two dates Rectangle.796 Formula to know the number of Friday the 13th between two dates Formula to know the number of Friday the 13th 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((WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=6)*(DAY(ROW(IN… =SUMPRODUCT((WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=6)*(DAY(ROW(INDIRECT(A1&":"&A2)))=13)) Dynamic connector.799 Dynamic connector.802 gives gives Dynamic connector.801 example example Sheet.77 Sheet.78

Usman Zafar Paracha

Usman Zafar Paracha is a sort of entrepreneur. He is the author of "Color Atlas of Statistics", and the owner of an Android game "Faily Rocket."

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.