How to extract day, month or year from a date

To extract day, month or year from a date, you use the corresponding Excel built in function for each one of these date parts.

  • Day: Day(mydate).
  • Month: Month(mydate).
  • Year: Year(mydate).

Examples:

Suppose you have in cell A1 (formatted as date), the date:15/11/2009 (ddmmyyyy), Then:

  • Day(A1) will result in 15
  • Month(A1) will result in 11
  • Year(A1) will result in 2009

Applies to: Excel 2003

Comments

  1. Sandeep Negi says:

    Dear Sir,
    It did not work out as u have given hints & formulas. As i wanted to extact month from date

    10-Feb-09 = 2-Jan-00
    10-Feb-09 = 2-Jan-00
    10-Feb-09 = 2-Jan-00
    10-Feb-09 = 2-Jan-00
    10-Feb-09 = 2-Jan-00

  2. admin says:

    Sorry I did not understand your problem.
    Can you give an example of the formula you entered and the result you got.

  3. Jayne says:

    Dear Sir,

    It worked for me, however in the result I would like it to spell out the month. Example: A1 is January 6, 2010, I would like the other cell to say Jan’10. The formula that I’m using is: =MONTH(A1)&”‘”&YEAR(A1)

    Thank you!

  4. admin says:

    No need to use any function. Just custom format the date field as follows:

    mmm’yy