Grouping Date for Pivot Tables

[Livin404]

Good evening, I'm have a little issue with ungrouping my dates. My pivot table works great. There is one area I'm trying to improve upon. I have a date for example 12 Feb 24. When I ungroup them I successfully split them my year and month. However, it will not allow me to get the day unless I want the month attached too. For example rather than getting 12 for the day, I'm getting 12-Feb. This is not efficient for me since I use slicers and I don't want the slicers buttons to have the day followed by the month. Currently I had to make a work around by adding another column in my database just to get this result. I'm using the formula =IF(A337="","",DAY(A337)) to get an individual day. I'm trying to get rid of this, since I use a user form to enter my data and it is not perfect when I have to update a line in my database.

Thank you,

 

[RoryA]

As you should already know:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Redirecting

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.