I am managing ad contracts and needing to include the year of their creation date plus the contract number in the first column. I use a formula that pulls data allowing me to have at-a-glance info for tracking our ads. Example:
the column is called C...