How to group by date in excel? – Super User
Posted by jpluimers on 2016/10/10
Sometimes you don’t recognize how easy it is until you see it:
Add a column that is of type date with value =FLOOR(A2,1) .Then Insert -> Pivot Table. Then drag the date column on the right into the Rows box, and also drag it into values box. Done.
Thanks David d C e Freitas!