Want to see only this week’s data in Google Sheets? If your columns are dated, you can filter them dynamically to show just the current week. In this guide, we’ll show you how to filter columns by current week in Google Sheets so your spreadsheet always stays up-to-date.
Whether you’re tracking employee attendance, sales, or time-based data, this method ensures you only see the relevant columns for the current week.
Why Filter Columns by Current Week in Google Sheets
Filtering columns by the current week helps you:
- Focus on relevant data
- Reduce clutter in your spreadsheet
- Automatically update as the week progresses
This technique is particularly useful for dashboards, weekly reports, and dynamic datasets.
How to Filter Columns by Current Week in Google Sheets
To filter columns by the current week, you’ll use:
- FILTER function to extract the relevant columns
- WEEKNUM function combined with
TODAY()to determine the current week - HSTACK function to include other important columns like names or categories
Sample Dataset
Assume your spreadsheet has:
- Column A: Employee names
- Columns B–AF: Daily attendance or dated data
- Sheet name:
'employee data'
Goal: Display only the employee names and columns where the header date falls in the current week. This view should update automatically each week.
Step 1: Filter Current Week Columns
Use this formula to filter only the columns where the date falls in the current week:
=FILTER('employee data'!B2:AF, WEEKNUM('employee data'!B2:AF2, 1)=WEEKNUM(TODAY()))Instructions:
- Paste this formula in cell
A1of a new sheet. - It will filter all columns with dates in the current week.
Tip:
WEEKNUM(..., 1)treats Sunday as the start of the week.- Use
2instead of1if you want Monday as the start of the week.
Step 2: Include Employee Names with Current Week Columns
To combine the first column (employee names) with the filtered week columns, use HSTACK:
=HSTACK(
'employee data'!A2:A,
FILTER('employee data'!B2:AF, WEEKNUM('employee data'!B2:AF2, 1)=WEEKNUM(TODAY()))
)This formula creates a dynamic table showing:
- Employee names
- Only columns for the current week
The result updates automatically as weeks change, making it perfect for weekly reporting.
Tips for Using This Method
- Ensure your header row contains valid date values.
- Adjust WEEKNUM parameter according to your week-start preference.
- Combine with conditional formatting to highlight current week data.
FAQs
Q1: Can I filter columns by a different week instead of the current week?
Yes. Replace TODAY() with any specific date, and WEEKNUM will calculate the corresponding week.
Q2: What if my dataset has multiple category columns?
You can include multiple columns within a single HSTACK function to combine them with the filtered data. For example:=HSTACK('employee data'!A2:B, ...) =HSTACK('employee data'!A2:A, 'employee data'!Z2:Z, ...)
Q3: Can this work for monthly filtering?
Yes. Instead of WEEKNUM, use MONTH() in the FILTER formula to filter by the current month.
