Forum Discussion
Grouping by dates in Excel?
How do you group dates that fall within specific date ranges? Is it by formula or by grouping by month, but the grouping won't work if you want an odd date range like from the 9th of one month to th...
Deleted Riny_van_Eekelen ExcelExciting
Would you know why Excel can't do this period automatically when selecting Grouping by month in a pivot table? Maybe there is a period option?
MMH11 Well, I guess Excel uses standard periods such as calendar weeks, months, quarters and years. And then you can group by x number of days (like 28 days = 4 weeks). Grouping from the 15th of one month till the 14th of the next may be 30 days one month, 31 days another and sometimes 28 or 29 days. So, thats not a fixed number of days either. But why Excel can't do it by default, I can't tell. Perhaps, that's why they came up with EOMONTH.