Forum Discussion
Solved
Cant use MAXIFS for date range
Hi all,
I have some trouble using the MAXIFS function to sort out for example the latest invoice in each project. What am I doing wrong, I get 0 or 1900-01-00 as an answer.
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.
These are the columns I use, I want the result to be the latest invoice date (fakturadatum) in each project.
