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)
The occurrences for represented as a numeric value, Monday = 1, Sunday = 7.


Example

 A
1=TODAY() = Thursday 01 December 2022
2=NOW() = Thursday 01 December 2022 06:02:29
31
4=TODAY() = 01/12/2022
5=A4 = Thursday
614
7=A4+A6 = 15/12/2022
8=A7 = Thursday
9=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A4&":"&A7)),2)=A3)) = 2

1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
3 - Displays the date formatted in long date format
4 - Displays the number of days that you want to add
5 - Displays the last date
6 - Displays the date formatted in long date format
7 - Displays the date


Built-in Functions

TODAY - The date serial number representing today's date.
NOW - The date serial number of the current system date and time.
SUMPRODUCT - The sum of the product of one or more arrays of values.
WEEKDAY - The day of the week for a given date.
ROW - The row number of a cell reference.
INDIRECT - The text string of the contents of a given cell reference.


Related Formulas

blank


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