Easy steps to get beginning of year, month or week in Excel

July 22, 2022
18.3K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

When working on many financial and other worksheets, the date is a crucial factor. We frequently need to enter the beginning of a month, year, or week depending on our needs. For example, if you want to know the date at which the week begins from a certain date to plan the week accordingly then you can use excel for this purpose.


Thanks to the excel, you can get the beginning of the month, excel also help you to get beginning of week or year using simple functions.

How to get beginning of month in excel

We frequently need to enter a beginning of month to excel. A quick remedy is available to determine the beginning of the month in excel. We will discover how to obtain the beginning of month in excel with this tutorial.

1.Write the dates from which you need beginning of month in a column.



2.Click on the cell where you want the beginning of month to display.

3.Use the formula: =date-DAY(date)+1, you will write the cell name containing date in the place of date in formula.


4.Press the enter key. This should display the beginning of month in excel.



By using this formula, you can easily get beginning of month in excel.

How to get beginning of week in excel

In order to find out the beginning day of week by any given date, follow this stepwise tutorial.

1.Write the dates from which you need beginning day of week in a column.



2.Click on the cell where you want the beginning of week to display.

3.Use the formula: =A2-WEEKDAY(A2,2)+1, where A2 represent the number of cell containing original date.



4.Press the enter key. This should display the date corresponding to beginning of week.


The above method will give Monday as the beginning of the week. By following this method you can get beginning of week in excel.

How to get beginning of year in excel

In order to get the beginning day of year by any given date, follow this stepwise guide.

1.Write the dates from which you need beginning of year in a column.



2.Click on the cell where you want the beginning of year to display.

3.Use the formula: =DATE(year,1,1), where you will write year for which you want to return the first day.



4.Press the enter key.



All WPS versions, including the 2016/2019 versions, are compatible with the above tutorials. Every version is available on various platforms such as iPhone, mac, android or windows. Additionally, Excel can be used without an internet connection, so you don't need to be online, thus it can be used whenever and wherever you want.


Did you learn how to access the first of the year, the month, and the week in Excel? To discover more about the functionality of Word documents, Excel spreadsheets, and PowerPoint slides, follow WPS Academy.


You can also download WPS Office for free if you want to edit Word, Excel, or PowerPoint documents. Get it now! and enjoy a simple and fun working environment.