Excel Formulas to Get the First Day of Month ~ A Complete Guide!!
Tags: excelformula, excelformulas
Published: 2021-05-17 04:21:21

---
title: Excel Formulas to Get the First Day of Month ~ A Complete Guide!!
published: true
date: 2021-05-15 06:32:04 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-get-the-first-day-of-month/
---

Assume that you have a list of dates, and you need to find out the first day of the given date. How could you quickly solve this in Excel? In this tutorial, we will show the easiest formula to **get the first day of the month in Excel**. Let’s get them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Get first day of month](https://geekexcel.com/wp-content/uploads/2021/05/Get-first-day-of-month.png)](https://geekexcel.com/excel-formulas-to-get-the-first-day-of-month/get-first-day-of-month/#main)<figcaption id="caption-attachment-42276">Get the first day of the month</figcaption>

## Generic Formula:

- You can use the below formula to get the first of the month in Excel.

**=date-[DAY](https://geekexcel.com/how-to-use-excel-day-function-in-office-365-with-examples/)(date)+1**

## Syntax Explanations:

- **DAY** – In Excel, the **[DAY function](https://geekexcel.com/how-to-use-excel-day-function-in-office-365-with-examples/)** helps to return the day of the date.
- **Date** – It specifies the input values from your worksheet.
- **Plus operator (+)** – This symbol is used to add the values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Minus Operator (-)** – This symbol will help to subtract any two values.

## Example:

Refer to the below example image.

- Here, we will enter the input values in **Column B**.
- Now we are going to get the first day of the month.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-30.png)<figcaption id="caption-attachment-42273">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-47.png)<figcaption id="caption-attachment-42275">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result1-1.png)<figcaption id="caption-attachment-42274">Result</figcaption>

## Wrap-Up:

Hope you like this article on how to **get the first day of the month in Excel**. Let me know if you have any  **doubts**  regarding this article or any other Excel/VBA topic.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas to Get Days Between Dates Ignoring Years ~ Quick Tips!!](https://geekexcel.com/excel-formulas-to-get-days-between-dates-ignoring-years-quick-tips/)**
- **[How to Count missing values in a list in Excel Office 365?](https://geekexcel.com/how-to-count-missing-values-in-a-list-in-excel-office-365/)**
- **[Excel Formulas to Test the Date is Workday or Not ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-test-the-date-is-workday-or-not/)**
- **[Excel Formulas to Create Custom Weekday Abbreviation ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-create-custom-weekday-abbreviation/)**