Willow Tips

Tip #2000-4: Formatting Dates Correctly with Live Data

Formatting the cell to look like a date

You can use one of Excel's built-in date formats, or create your own, as we have here. We wanted to display the year in 4 digits. Using 4 digit years is great protection against Year2000 difficulties.