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?"
2 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.
