Monday, 22 July 2013

Excel Text Function to get Day,Month,Year Values from a Date Value

Excel Text Function to retrieve Day,Month and Year Values from a Date Value
We can get the part of a Date value like Day , Day Name , Month, Month Name , Year values in Excel using the Text Function.

Go through the following example to understand how this stuff works. This is really very use full.

Example:


DATE
REQUIREMENT
FORMULA
RESULT
7/25/2015
Day Value
 =TEXT(A2,"dd")
25

Day Name
 =TEXT(A2,"dddd")
Saturday

Month Value
 =TEXT(A2,"mm")
07

Month Name
 =TEXT(A2,"mmmm")
July

Year Value
 =TEXT(A2,"yyyy")
2015

Day and Month
 =TEXT(A2,"dd/mm")
25/07

Month and Year
 =TEXT(A2,"mm-yyyy")
07-2015

Month Name and Year
 =TEXT(A2,"mmmm,yyyy")
July,2015

Thanks,
TAMATAM

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts