Easy steps to get week, day and month from date in excel
A free Office suite fully compatible with Microsoft Office
When you are working with data which contain lots of date, you might need to extract month from date in excel. Even you might need to know day number or week number from date.
Excel knows which components of the date you entered relate to the month, year, and date. Thus, you can extract all the particular parts of your choice from the date. Be it name of the day, number of the day, number of the week, month, year, etc.
Here in the stepwise tutorial on how to you can use excel to get month from date, week or day number from date in excel. All the tutorial provided are compatible with 2016/2019 versions.
How to use excel to get month from date
We can get month name from date using the text function. Before we get into the tutorial, you should know about formats in which you can display month.
m – represents month name in one digit (9 and 12)
mm – represents month name in two digit (09 and 12)
mmm – represents month name in short form (sep and dec)
mmmm - represents month name in full (September and december)
You can follow this stepwise tutorial in excel to get month from date.
Write the date from which you want to get month in a column
Select the cell where you want to display month
Write the formula: =TEXT(A2,mmmm), where A2 is the cell containing date and mmmm is the format of your choice.
Press enter and this should display the monthfrom date.
How to get week number from date in excel
Write the date from which you want to get week number in a column.
Select the cell where you want to display week number.
3. Write the formula: =WEEKNUM(A2), where A2 is the cell containing date.
Press enter and this should display the week number from the date.
Note that the week number corresponds to the week of the year and not the week of the month.
How to get day number from date
Write the date from which you want to get day number in a column.
2. Select the cell where you want to display day number.
Write the formula: =A2-DATE(YEAR(A2),1,0), where A2 is the cell containing date.
Press enter and this should display the day number from the date.
Note that the day number corresponds to the day of the year and not the month. But if you want to get the day number of the month, simply use the formula: =DAY(A2) instead of the one mentioned above and this will give you the day number of the month.
Did you learn about how to use excel to get month, day number, week number from date? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides.
Also, WPS office can be used across various platforms such as windows, mac, iPhone etc. WPS office works without internet as well so you don’t need to be online for using excel spreadsheet.
You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.
Was this helpful?
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. How to compare two excel sheets and highlight differences
- 3. Check if value is in list in Excel (3 easy methods)
- 4. How to copy file names in Excel from a folder?
- 5. How to color cell based on value in Excel?
- 6. How to add month name from date in Excel formula