Table of Contents
To obtain the first day of the month in Google Sheets, you can use the function “=EOMONTH(date, 0)+1”, where “date” is the reference to the desired month. This formula will return the date of the first day of the specified month. Alternatively, you can manually input the date by typing “=DATE(year, month, 1)”. This will also give you the first day of the month. Both methods will provide the desired result and can be easily applied to any cell in the spreadsheet.
Get First Day of Month in Google Sheets
You can use one of the following formulas to get the first day of the month for a date in Google Sheets:
Formula 1: Use DAY() Function
=A2-DAY(A2)+1
Formula 2: Use EOMONTH() Function
=EOMONTH(A2,-1)+1
Both formulas will return the first day of the month for the date in cell A2.
The following examples show how to use each formula in practice with the following dataset in Google Sheets:
Example 1: Get First Day of Month Using DAY()
We can type the following formula into cell C2 to get the first day of the month for the date in cell A2:
=A2-DAY(A2)+1We can then drag and fill this formula down to each remaining cell in column C:
Column C now displays the first day of the month for each date in column A.
Here’s how this formula works:
- The DAY() function returns the day of the month between 1 and 31.
- Thus, A2 – DAY(A2) returns the last day of the previous month.
- Then, we add one to get the first day of the month for the date in cell A2.
Example 2:Get First Day of Month Using EOMONTH()
=EOMONTH(A2,-1)+1We can then drag and fill this formula down to each remaining cell in column C:
Column C now displays the first day of the month for each date in column A.
Here’s how this formula works:
- The EOMONTH() function returns the last day of the month for a date.
- The function EOMONTH(A2, -1) returns the last day of the previous month.
- Then, we add one to get the first day of the month for the date in cell A2.
You can find the complete documentation for the EOMONTH() function in Google Sheets .
Cite this article
stats writer (2024). How can I get the first day of the month in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-get-the-first-day-of-the-month-in-google-sheets/
stats writer. "How can I get the first day of the month in Google Sheets?." PSYCHOLOGICAL SCALES, 23 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-get-the-first-day-of-the-month-in-google-sheets/.
stats writer. "How can I get the first day of the month in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-get-the-first-day-of-the-month-in-google-sheets/.
stats writer (2024) 'How can I get the first day of the month in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-get-the-first-day-of-the-month-in-google-sheets/.
[1] stats writer, "How can I get the first day of the month in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I get the first day of the month in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.