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.


Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
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
1=TODAY() = Sunday 01 May 2022
2=NOW() = Sunday 01 May 2022 18:37:54
31
4=TODAY() = 01/05/2022
5=A4 = Sunday
614
7=A4+A6 = 15/05/2022
8=A7 = Sunday
9=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A4&":"&A7)),2)=A3)) = 2

Built-in Functions

TODAY - The serial number representing today's date.
NOW - The 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