Originally Posted by
dalecooper
Hi everyone
I have just decided to sign up for this forum as I'm constantly bashing my head against the table trying to work things out. Sometimes it's a good way to learn but on other occasions I'm stumped!
So, sorry if my questions are dumb.. any help is much appreciated though so thanks in advance.
I'm using a vlookup between worksheets. I have reference numbers on both sheets in Column A.. so finding a match is simple. Now, I have set my formula to return the corresponding date from the 2nd worksheet. My problem lies in the format that the dates return in. For example:
21/01/2011 comes back to my sheet as 40564
Now, when I go to format it to a date, the cell displays 22/01/2015
I'm probably being stupid, but it's getting frustrating! Sorry if I forgot to include any vital info in this post. Thanks!
Bookmarks