Automatically run a macro when opening a workbook
You might want a macro you recorded to run automatically when you open a specific workbook. The following procedure uses an example to show you how that works. You may also want to run macros automatically when Excel starts. Newer Windows versions Newer Mac versions.
CELL function - Microsoft Support
The CELL function syntax has the following arguments: info_type values. The following list describes the text values that can be used for the info_type argument. These values must be entered in the CELL function with quotes (" "). CELL format codes.
YEAR function - Microsoft Support
Description. Returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999. Syntax. YEAR (serial_number) The YEAR function syntax has the following arguments: Serial_number Required. The date of the year you want to find.