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

Data Analysis

  • How To Compare Two Lists in Excel
  • Example of COUNTIFS with variable table column in Excel
  • How to Create Thermometer Chart in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How To Load Analysis ToolPak in Excel

References

  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Count rows with at least n matching values
  • Merge tables with VLOOKUP in Excel
  • How to get last row in mixed data with blanks in Excel
  • How to get last row in text data in Excel

Data Validations

  • Excel Data validation date in specific year
  • Excel Data validation specific characters only
  • Excel Data validation must begin with
  • Prevent invalid data entering in specific cells
  • How To Create Drop-down List in Excel

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

 

Worked Example:   EOMONTH function: Description, Usage, Syntax, Examples and 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.

Worked Example:   How to calculate workdays per month in Excel

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:

Get days between dates ignoring years in Excel

Next Post:

Get date from day number in Excel

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

  • How to use Excel AND Function
  • How to use Excel TRUE Function
  • Nested IF function example in Excel
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel

Date Time

  • DAYS function: Description, Usage, Syntax, Examples and Explanation
  • Add business days to date in Excel
  • Count day of week between dates in Excel
  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • Convert text timestamp into time in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • Group times into unequal buckets in Excel
  • Map text to numbers in Excel

General

  • Print Excel Sheet In Landscape Or Portrait
  • How to calculate percent sold in Excel
  • How to generate random number weighted probability in Excel
  • How to Delete Cells, Row and Rows in Excel
  • Select, Insert, Rename, Move, Delete Worksheets in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning