Notifications
Clear all
Topic starter
How to write a macro to group the date [ mid of the month , end of the month]
pls refer attached
Posted : 08/06/2018 9:09 pm
Hi David
In cell E2 enter :
=IF(DAY(D2)<=15,"Mid","End")
Hope this helps
Sunny
Posted : 08/06/2018 9:42 pm
Topic starter
Thanks Sunny got it ...
Have a ncie weekend..
Posted : 08/06/2018 9:54 pm
Topic starter
But how to sort /group the date in pivot table chronologically ??
Posted : 11/06/2018 9:46 pm
Hi David
The problem is your Net Due Date1 is not a true date but text.
Just put a formula in column H example =G2
Custom Format the column G to mmm-yy and then recreate your PivotTable using this column.
Hope this helps.
Sunny
Posted : 11/06/2018 10:35 pm
Topic starter
Yes it works, but how to group by month summary ?
Posted : 11/06/2018 11:08 pm
Just right-click on the row label and select Group
Then select Months and Years
Posted : 11/06/2018 11:13 pm
Topic starter
Yes, got it , thanks Sunny.
Posted : 11/06/2018 11:43 pm
