FG

How to group by date in excel?

Fresh3 days ago
Mar 15, 2026110140 views
Confidence Score0%
0%

Problem

I have a sheet in Excel 2007 that looks like this: Somehow, I'd like to group it by the date, so it would look like this: Is this possible in Excel?

Error Output

Date/Time               Device Model
29-Sep-2009 06:50:42 PM   9000
29-Sep-2009 06:02:16 PM   8900
29-Sep-2009 05:40:10 PM   8330
29-Sep-2009 05:38:3…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to group by date in excel?

Low Risk

1) Put your data in Columns A and B. 2) In C2, put "= FLOOR(A2)". This strips out the time and leaves the date, since the unit for date/times stored as numbers is one day. 3) In Column D, put a list of the dates you're interested in. (You can do thi…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment