Today when I was doing my daily reporting tasks in Microsoft Excel, in my mind few generic questions came:
- Is there any function of Excel to convert a date to weekday name?
- Is there any function of Excel to convert a date to month name?
- Is there any function of Excel to convert a date to year?
And the answer of all these queries is TEXT function.
Below are the steps to convert a date to weekday name, month name and year.
Assume that cell A2 of your worksheet contains the date that you want to reference.
Convert Date to Weekday Name
If you want to return the day of the week as a whole word (for example, as Wednesday), use the TEXT function in the cell that you want to return the day of the week, and then press ENTER:
=text(a2,”dddd“)
To return the day of the week as an abbreviation (for example, as Wed): =text(a2,”ddd“)
Convert Date to Month Name
If you want to return the month name as a whole word (for example, as January), use the TEXT function in the cell that you want to return the day of the week, and then press ENTER:
=text(a2,”mmmm“)
To return the month name as an abbreviation (for example, as Jan): =text(a2,”mmm“)
Convert Date to Year
If you want to return the Year (Years as 1900–9999), use the TEXT function in the cell that you want to return the year, and then press ENTER:
=text(a2,”yyyy“)
To return the Year as Years as 00–99: =text(a2,”yy“)
Below are the codes you can use with TEXT function:
Hello! This is kind of off topic but I need some help from an established blog. Is it hard to set up your own blog? I’m not very techincal but I can figure things out pretty quick. I’m thinking about creating my own but I’m not sure where to start. Do you have any points or suggestions? Many thanks
There’s noticeably a bundle to find out about this. I assume you made sure good points in options also.
Hi there! Such a good article, thank you!