I have converted (almost) of the following to work in XCode – except the last line pertaining to “year of”
tell application "Microsoft Excel"
set theRange to get range "Date" of active sheet
tell theRange to set theValue to value of cell 1 of row 1
set aYear to year of theValue
end tell
Thanks for bailing me out.