what Excel function should i use that will output an employee code based on
the hired date?

example:
empcode name date hired
A050401 John Evans - 04/01/05

syntax of empcode is (companycode-yr hired-month hired-number sequence)