Excel Forum
Similar Content
Create a Custom Function in Excel - UDF
Tutorial: How to create a custom worksheet function in Excel. These are called User Defined Function...
How to Find and Understand Excel Functions
Tutorial: In this tutorial I am going to show you how to find and understand new Excel Functions. If...
How to Add Boxes, Buttons, Arrows, Speech-Bubbles, Hearts, and More to a Spreadsheet in Excel
Tutorial: In this tutorial I am going to cover inserting and editing Shapes in an Excel workbook, as...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.