Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Get column name from index in Excel Table
  • How to Create One and Two Variable Data Tables in Excel
  • Excel Frequency Function Example
  • Conditional Formatting Icon Sets Examples in Excel
  • Example of COUNTIFS with variable table column in Excel

References

  • Count rows with at least n matching values
  • How to get first column number in range in Excel
  • Find closest match in Excel
  • Approximate match with multiple criteria in Excel
  • Two-way lookup with VLOOKUP in Excel

Data Validations

  • How To Create Drop-down List in Excel
  • Data validation must not exist in list
  • Excel Data validation date in next 30 days
  • Excel Data validation allow weekday only
  • Prevent invalid data entering in specific cells

Get first day of month in Excel

by

This tutorial shows how to get first day of month in Excel using the example below.

To get the first day of the month for a given date, you can use a simple formula based on the DAY function.

Formula

=date-DAY(date)+1

In the example shown, the formula in cell C5 is:

=B5-DAY(B5)+1

Explanation

 

The DAY function returns the day value for a date. In the example show, the day value for the date in B5 (January 11, 2016) is 11. Because dates are just serial numbers in Excel, we can subtract 11, then add 1 to get the date value for January 1, 2016.

Alternative with EOMONTH

The EOMONTH function returns the last day of in the month of a given date. This means you can get the first day of the current month with a formula like this:

=EOMONTH(A1,-1)+1

This formula “rolls back” a date in A1 to the last of the previous month, then adds 1. The result is the first day of the “current” month (i.e. first day of the month given by the date in A1).

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • SWITCH function example in Excel
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • IF with boolean logic in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • OR function Examples in Excel

Date Time

  • Get fiscal year from date in Excel
  • Get fiscal quarter from date in Excel
  • Display Days in month in Excel
  • Get day from date in Excel
  • How to calculate Quarter of Date in Excel

Grouping

  • Group arbitrary text values in Excel
  • If cell contains one of many things in Excel
  • Map text to numbers in Excel
  • Group numbers at uneven intervals in Excel
  • How to randomly assign data to groups in Excel

General

  • Creating and Opening an existing file in Excel
  • Currency vs Accounting Format in Excel
  • Hide and Unhide Columns or Rows in Excel
  • Convert column number to letter in Excel
  • Check if multiple cells have same value in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning