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.
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
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.
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top