Forum Discussion
Data info in separate date columns
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