I especially found corinereyes reply to be helpful. I needed to compare Hire Date to Service Date and I was able to easily use the example to do this and put in a special message. Now I just need to work out how to record a macro so that outsourcing team can run it every month on new spreadsheet that they run of prior month rehires.
Bookmarks