Number of occurrences of a particular day of the week

You can return the number of times a particular day of the week occurs between 2 dates (inclusive)
Cell "A1" display the day of the week you want the occurrences for represented as a numeric value, Monday = 1, Sunday = 7.
Cell "A2" display a date
Cell "A3" display the date formatted in long date format
Cell "A4" is the number of days that you want to add
Cell "A5" display the last date
Cell "A6" display the date formatted in long date format
Cell "A7"

 A
11
2=TODAY() = 02/12/2019
3=A2 = Monday
414
5=A2+A4 = 16/12/2019
6=A5 = Monday
7=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&A5)),2)=A1)) = 3

Built-in Functions

TODAY - The serial number representing today's date.
SUMPRODUCT - The sum of the product of one or more arrays of values.


Related Formulas

blank



© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top