Excel Forum

Excel Magic Trick 300: YEAR DATE TEXT functions for Date Label

See how to use the YEAR, DATE and TEXT functions and the ampersand (concatenation) to create a Date Label that adds leading zeros appropriately. See how to use the clipboard to gather copied elements for a formula.

Got a Question? Ask it Here in the Forum.