Function Problems

Count Records from the Start of the Current Week in Excel

Bushra ParveenBushra Parveen Nov 18, 2026 870 views

Question details

Count client records in the current week and automatically begin a new count each week.

Count Records from the Start of the Current Week in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Identify the columns

In your worksheet, locate the date column and client category column. The example uses dates in A2:A100 and categories in B2:B100.

2
Enter the formula

Select an empty cell and enter =COUNTIFS(A2:A100,">="&TODAY()-WEEKDAY(TODAY(),2)+1,A2:A100,"<"&TODAY()-WEEKDAY(TODAY(),2)+8,B2:B100,"Client").

3
Adjust the criteria

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.

Use COUNTIFS to Count Client Records in a Monday-Starting Week
Counting all categories: To count every dated record regardless of category, remove the final category range and criterion: =COUNTIFS(A2:A100,">="&TODAY()-WEEKDAY(TODAY(),2)+1,A2:A100,"<"&TODAY()-WEEKDAY(TODAY(),2)+8).
Count weekly records in WPS Spreadsheet

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. 1. Open your workbook: Open WPS Spreadsheet and select Open to load your Excel workbook.
  2. 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. 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. 4. Customize and save: Replace the ranges and category with your own, press Enter, and use File > Save to keep the formula.
Count dated client records within the current week.Open and edit Microsoft Excel XLSX and XLS files.Use familiar spreadsheet formulas and a straightforward interface.
microsoft office alternative - wps office

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.