•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
how to actually change the date and not just its appearance
Our take
If you're looking to effectively change the date in your pivot table without just altering its appearance, you're not alone. Many users encounter the challenge of retaining the day component when formatting dates. While using a custom format like 'mmm-year' can visually simplify your data, it doesn't change the underlying values. To unify dates like 10 Jan 2026 and 30 Jan 2026 into a single month-year format, consider using a formula to extract and convert the dates before creating your pivot table.
i am tring to do a pivot table with month-year formatting, so i went ot custom and wrote 'mmm-year', visually all the cells looks good, but in the formula tab the days are still there, i tied copy pasting only values and still no luck
and tis is what is shown in the formula, it is bad becuase i need all the dates in a pivot table but days mess this stuff, 10/jan/2026 is diffrent than 30 jan/2026 and i want them to be one
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- problem with pivot table date columnsi had full dates, then i made them only mm/yyy type, but when put in the pivot table they still count the same month as different columns because they still count the days in, even though i changed it to mmm/yyy https://preview.redd.it/jds1lkbg9xtg1.png?width=1088&format=png&auto=webp&s=869a4bf431c54e6e9603d3cb25fe2bc53981b64b https://preview.redd.it/l8px4ijk9xtg1.png?width=164&format=png&auto=webp&s=01a8e47a9b24ba184aa097af2c212e453ec1c4b2 thats the view from the forula tab, idk why they still count the days, how do i solve this? https://preview.redd.it/wtsz4wrl9xtg1.png?width=283&format=png&auto=webp&s=5cd03a6a328ee992de70b209e429441f11294188 submitted by /u/PurpleDurian7220 [link] [comments]
- Pivot table french date 'month' format in grouped datesHi Excel, I want to change the grouped dates month format from french to english. What is strange is that my excel is in english except this. Any idea how I can change the "Janv, Févr etc." to "Jan, Feb, etc."? Any help appreciated! https://preview.redd.it/w5uyg7nwhh0h1.png?width=516&format=png&auto=webp&s=9ad0cd80c150af239e1f830826c6f04fa61106a4 submitted by /u/jacqueschirekt [link] [comments]
- How to when entering month have the day and date changeOn my timesheet I input the month and year 'May 2026' and when this happens I need the column with days of the week and then adjacent column with the numerical date (1, 2 etc) to then change. Please I cannot figure it out submitted by /u/Pineapplegirl1 [link] [comments]
- How to change formatting of textHi everyone! I would like to ask for your help regarding the formatting of data in excel. So currently, I have list of dates however these dates are formatted as follows: MM/DD/YYYY ( example: 04/02/2024) I wanted to change the format to date to Month-Day-Year (02-Apr-2025) format but I dont know how to, Ive been trying to research about it. I have list of transactions and I really need to do it in bulk mode. Any suggest for a possible formula on this one? Help you Big 4 helpless dying auditor out. submitted by /u/flagrantly_mediocre [link] [comments]
Tagged with
#AI formula generation techniques#formula generator#rows.com#Excel compatibility#Excel alternatives for data analysis#financial modeling with spreadsheets#Excel alternatives#pivot table#dates#Excel#month-year formatting#custom format#mmm-year#formula tab#data formatting#differentiation#copy pasting#days#date modification#data analysis