Excel tricks: Parsing out the date

If you have a column with the date in the month/day/year format and you want to create separate columns for day, month, and year, Excel is nice enough to do that for you:

In cell A1, you have 01/02/2001
In cell B1, type =DAY(A1) and Excel will update B1 to read "2"
In cell C1, type =MONTH(A1) and Excel will update C1 to read "1"
In cell D1, type =YEAR(A1) and Excel will update D1 to read "2001"