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 each quarter column. People who use our service and we put information in quarterly report column. See this example below.
Name. - age - gender - race Quarter 1 (Jan to March). Quarter 2 (April to June) Quarter 3 (July to Sept), Quarter. 4 (Oct to Dec)
I need to separate the group of data into each quarter column so it won't repeat in other quarters using the formula on excel. I have used COUNTIF to calculate the group for each quarter column. I tried DATE but I got error, "#NAME?"
3 Replies
That error means Excel doesn’t recognize the function or formula. Common causes:
- Typo in function (e.g., DATE spelled as DAET)
- Using regional format (e.g., commas vs semicolons)
- Misuse of DATE without wrapping in a valid function
Try this test formula in a blank cell:
=DATE(2024,1,1)
If that gives an error, your Excel is using non-English settings, and you might need to use ; instead of ,.
Additional information (such as Excel version, operating system, storage medium, etc.) would help to make the solution more concrete. An attached file (without sensitive data) with the problem would be best.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
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
