Forum Discussion
Data info in separate date columns
I need to put data information in separate date columns in the same excel project. Let me give you an example. The project have 4 quarters lasting 3 months each. I need to put data information on ea...
No. You misunderstood my question. Please read my question carefully again.
You have data like: Ist hat corect?
Name | Age | Gender | Race | Service Date |
Alice | 34 | Female | Asian | 2024-02-15 |
Bob | 41 | Male | White | 2024-05-20 |
Carla | 29 | Female | Black | 2024-10-10 |
You want to categorize each person into a quarterly column, like:
Name | Age | Gender | Race | Q1 (Jan–Mar) | Q2 (Apr–Jun) | Q3 (Jul–Sep) | Q4 (Oct–Dec) |
Each person should appear in the quarter their service date falls into.
Please explain your task better, insert a file or a photo for better understanding.
Thank you for your understanding and patience