Monday, 22 July 2013

How to get Day,Month and Year Values from a Date in Excel

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

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts