Forum Discussion

Richelle Grajo's avatar
Richelle Grajo
Icon for Microsoft rankMicrosoft
May 08, 2018

Pivot table question

Hello, I need to create a pivot table that includes names and pivot each name based on their service dates for 1 year, 5 year, 10 year, etc.   How do I group all the names together within a speci...
excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
May 08, 2018

Hi Richelle,

 

In the attached file, you will find a similar approach to what you are asking for.

This is done by using a Table, not a PivotTable.

 

Hope that helps

Haytham

  • Richelle Grajo's avatar
    Richelle Grajo
    Icon for Microsoft rankMicrosoft
    May 08, 2018

    Yes, this is what I need to do.  How do I create an employee table?  Do you mind creating steps to accomplish this?

     

    Thanks.

    • Richelle Grajo's avatar
      Richelle Grajo
      Icon for Microsoft rankMicrosoft
      May 08, 2018

      I was able to use your formula..   Thank you so much!!

      • Richelle Grajo's avatar
        Richelle Grajo
        Icon for Microsoft rankMicrosoft
        May 08, 2018

        Hi,

        Instead of calculating the years for today, how do I calculate the years for June 2018?

         

        Thank you,

         

         

         

Resources