Forum Discussion
Cant use MAXIFS for date range
Exceed I suspect that the dates in column Q are in fact texts. So, MAXIFS always returns 0. If the cell with that formula happens to be formatted as a date you get 0 January 1900.
Use Text to columns from the Data ribbon to transform the date texts to real date values.
Exceed I attached a mock-up of your schedule and suspect that the criteria you try to match are not presenting the criteria range. Your formula seems to be correct otherwise.
- Thanks for your quick reply btw.
Exceed I suspect that the dates in column Q are in fact texts. So, MAXIFS always returns 0. If the cell with that formula happens to be formatted as a date you get 0 January 1900.
Use Text to columns from the Data ribbon to transform the date texts to real date values.
- I really appreciate your support solving this issue, I didn´t realize Excel didn´t understand that column was date until I used Text to columns. Now it works and saves me a huge amount of time. Have a great day!
These are the columns I use, I want the result to be the latest invoice date (fakturadatum) in each project.
