Count Records from the Start of the Current Week in Excel
Question details
Count client records in the current week and automatically begin a new count each week.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains dated client records that need to be counted by week and, optionally, by client category.
- Observed behavior
- The desired count updates with the current date and includes only records in the current week.
Check that the date column contains actual Excel dates rather than text. Identify the date and category ranges, and make sure they cover the same rows.
Use COUNTIFS to Count Client Records in a Monday-Starting Week
Use this formula to count a client category from the current Monday through Sunday, with the week changing automatically.
The lower date limit is the current Monday, and the upper limit is the following Monday. Using a less-than upper limit also includes dates with time values on Sunday.
In your worksheet, locate the date column and client category column. The example uses dates in A2:A100 and categories in B2:B100.
Select an empty cell and enter =COUNTIFS(A2:A100,">="&TODAY()-WEEKDAY(TODAY(),2)+1,A2:A100,"<"&TODAY()-WEEKDAY(TODAY(),2)+8,B2:B100,"Client").
Replace A2:A100 and B2:B100 with your matching ranges, and replace "Client" with the category you want to count. Press Enter to display the total.

Track Current-Week Client Records in WPS Spreadsheet
Use COUNTIFS, TODAY, and WEEKDAY in WPS Spreadsheet to calculate a client total that moves to the new week automatically.
- 1. Open your workbook: Open WPS Spreadsheet and select Open to load your Excel workbook.
- 2. Check the source columns: Find the date and client category columns. For the example below, use dates in A2:A100 and categories in B2:B100.
- 3. Add the weekly count: Select an empty cell and enter =COUNTIFS(A2:A100,">="&TODAY()-WEEKDAY(TODAY(),2)+1,A2:A100,"<"&TODAY()-WEEKDAY(TODAY(),2)+8,B2:B100,"Client").
- 4. Customize and save: Replace the ranges and category with your own, press Enter, and use File > Save to keep the formula.

Frequently Asked Questions
How does the formula find the start of the week?
TODAY()-WEEKDAY(TODAY(),2)+1 returns the Monday of the current week. The second date criterion excludes the following Monday and later dates.
How can I count records in a Sunday-starting week?
Use TODAY()-WEEKDAY(TODAY(),1)+1 for the lower limit and TODAY()-WEEKDAY(TODAY(),1)+8 for the exclusive upper limit in COUNTIFS.
Does the formula count future records in the current week?
Yes. The formula counts all matching dates from Monday up to, but not including, the following Monday. To count only through today, replace the upper criterion with "<"&TODAY()+1.
Why is my weekly count showing zero?
Check that the dates are real date values, that the category text matches your criterion, and that the ranges cover the correct rows. Also check the device date and Excel's calculation settings if TODAY() appears out of date.




