I have a workbook with several worksheets. Col C (in all sheets) contains various dates (mm-dd-yyyy). I would like to name the various worksheets using the last 2 digits in the year portion of the min & max dates.

sheet 01-05, sheet 02-11, sheet 17-17, etc

Can that be done?