Hi guys,

I need a macro to calculate the age of a barn from its experiment code. The last two digits contain the year. If the year is between 30-99 its 19XX (if the year is 00-20 its in the 20XX). I've attached an example below.

Age Macro.xlsx

Any help would be greatly appreciated.