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.
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!
Exceed Var så god!!