How to add February 29 (leap year day) to Pivot table?

Jessica 0 Reputation points
2024-03-08T15:33:49.8+00:00

I noticed that that data in my pivot table does not include February 29th in the table, which is the leap year day. I'm not sure how to add it into the table, since it is formatted correctly in the other sheet. How would I be able to add this? Thanks!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,715 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 24,986 Reputation points Microsoft Vendor
    2024-03-11T02:18:16.27+00:00

    Hi,

    Could you provide a sample about your PivotTable?

    I suggest you check if you have enter the Year for the Date in Excel.

    Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.