Hi,

I'm trying to calculate the age of an experiment based on the following information:

The attached spreadsheet contains a column called 'Expt'. Within the code in the column is when the experiment has started - the last two digits of that code represent the year e.g. ADH4483, ADH4299, ADH2103. The first two are 1983 and 1999, while the last one is 2003.

So I'm trying to calculate the following: (current year - the starting year)+1

Help2.xlsm

Below are my attempts of doing this with the help of another user on this forum.

Any help would be greatly appreciated.

Please Login or Register  to view this content.
Finally, any code that takes the first two numbers between 20-99 is 1910-1999 while any code between 0-19 is 2000-2019. If this could be incorporated into the script that'd be amazing.