I am getting #N/A as results. I have all the data in the same format. The pay scale table is sorted by Employee number then start date. I have tried to upload sample of the file but it does not like the .xlsx extension.
Hi, I'd have thought it was the other way around! Anyway - I'd suggest to convert the text values to proper dates - one way that would probably work for you is to use the built in find and replace by finding "." and replacing with "-".