Based on one data entered in one cell and in another cell this is populated

attached is a new hire spreadsheet. I enter a hire date as 00/00/0000 but need it broke out into two other fields as the month name then month year (so a report can be ran).Then I have the region the employee lives. I set up the regions based on the states in a separate tab. When I enter the employee state I need the spreadsheet to look up what region they live and populated it on the worksheet where all the information is. I have attached a sample. I think this might be a If function but can't figure it out.

Try like this

EFdpiatt.xlsx

Again thank you so much.

You're welcome.

can I ask another question.
I have a termination date col. When I enter in that date can the entire row be moved to maybe the next tab called terminations???

That would require VBA code.
Post a new thread in that forum