•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I format my dates correctly?
Our take
Formatting dates correctly in Excel can be challenging, especially when dealing with datasets that include year-only formats, like "1987." If Excel isn't recognizing your dates properly in a pivot table, it may be due to the way the data is formatted. Instead of counting from zero, Excel requires a specific date format to interpret your years accurately. In this guide, we'll explore the steps to ensure your dates are formatted correctly, enabling seamless use in pivot tables and enhancing your data analysis experience.
Hi. Complete novice here. I have a dataset the has headers containing dates in year format example 1987. However when T custom.format this to yyyy excel does not seem to recognize it in my pivot table as it thinks it needs to count from 0 till 1987.
What am I doing wrong?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#rows.com#large dataset processing#dates#format#excel#year#custom.format#dataset#pivot table#1987#headers#recognize#count#data entry#novice#user#incorrect