Cannot group that selection

[ahmedsadak]

Morning all,

I have a very large excel sheet, over 25000 lines, the dates are brought in with a formula, (they need to remain a formula and is constantly updated) which i need to pivot and group, however i believe, because they are a formula excel will not group them when pivoted.
Can someone help? is there a work around? i dont mind adding a column next to it

 

[ahmedsadak]

I'd really appreciate any help on this really struggling, would it be an idea to use =date then bring in the first of each month?

 

[FormR]

the dates are brought in with a formula

Hi, what is the formula? Does it return a true date serial number or text that looks like a date?

 

[RoryA]

Please take a minute to read the forum rules, especially the one about cross-posting, and then add the relevant links. Thanks.