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() = Wednesday 13 November 2024
2	=NOW() = Wednesday 13 November 2024 19:58:05
3	1
4	=TODAY() = 13/11/2024
5	=A4 = Wednesday
6	14
7	=A4+A6 = 27/11/2024
8	=A7 = Wednesday
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 value of a given cell reference specified by a text string.

Related Formulas

blank