How to extract Year, Month, or Day from the Date in Excel?

If you need to use the year, month or day referred to in a date cell in a separate cell follow the step:

1. Lets say that cell A1 contains the date November 13, 2007 (entered as 13/11/2007 or 11/13/2007 depending on your date system). 
2. Now you want to extract the year i.e., 2007 from the date you entered. Simply enter the formula =YEAR(A1). 
3. Similarly you can extract the month and day from the date using the formulas =MONTH(A1) and =DAY(A1).