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. Sorry I did not understand your problem.
    Can you give an example of the formula you entered and the result you got.

  3. 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. No need to use any function. Just custom format the date field as follows:

    mmm’yy