Get first day of month

An excel formula to get first day of month

Related Functions

Sponsored Link

 Get first day of month
=date-DAY(date)+1

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

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

 
=B5-DAY(B5)+1

How this formula works

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

Sponsored Link

0 votes. 0 / 5