Thank you both, I understand that now, and have got it fixed.
That still leaves me with a bit of a problem though...
The date in cell B2 is actually a date. It is looking up from another tab in my real file how old an employee is, which is figured out using Jan 1, 2013 - his actual birthdate = years old (32). So I guess I need to look up that cell & have it return an actual # of 32. The only way I know how to do that is using the "text" command, but that doesn't work because then it's a text value instead of a #.
I've reattached the file with the changes, thanks![]()
Bookmarks