You are here: Home / Date and Time / How to extract day, month or year from a date

How to extract day, month or year from a date

January 8, 2009 By

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

Related posts:

  1. How to format a date with month in upper case
  2. Calculate the number of months between two dates
  3. Function to decide whether a year is a leap year or not
Filed Under: Date and Time, Functions Tagged With: , , ,

Comments

  1. Sandeep Negi says:
    March 10, 2010 at 11:14 am

    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:
    March 11, 2010 at 6:45 pm

    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:
    July 9, 2010 at 1:45 am

    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:
    July 11, 2010 at 7:54 pm

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

    mmm’yy