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.