Forum Discussion
Solved
INDEX & MATCH interrupted by Inconsistent Dates
Hello So I have TWO Issues. Issue #1: My formula in columns F(Outbound), G(Inbound), and H(Total) is only working properly for "Jennifer" AND only up until there is a interruption of chronological...
Hi,
The formula you use isn't correct, and some dates in column N are treated as text not as numeric dates.
Please check out the fix in the attached file.
Regards
Check out this link to see how I fix the dates:
https://send.firefox.com/download/98dda8067df5553f/#pdhegKMozYWC8ddr4XK6sg
If that doesn't help, the reason may be that there are inconsistent dates in your complete data.
If you can provide us with a sufficient sample to see what the problem is.
Here is a more complete worksheet so you can see what i'm dealing with 🙂 Haytham Amairah
Hi,
The dates have been fixed with the same steps I showed you.I guess it didn't work on your side because your Windows date system is in DD/MM/YYYY (UK format) while the dates are created in MM/DD/YYYY (US format).(Please note that the default dates format in Excel always follow the default dates format in the operating system)The cause of the problem is that some of them have hidden characters that make Excel read them as texts.So when you open the workbook, the numeric dates will show up as DD/MM/YYYY whereas the text dates will stay in MM/DD/YYYY which make a mix dates.In my Windows, I have the date system in US format, therefore the solution works in my side.Find the solution in the attached file.Hope that helps- Thank you SO MUCH! its now working as needed!