# how to get the first day of the current month with subtraction

#### fayez_MrExcel

##### Active Member
how can i subtract 1 month from the given date to get the first day of the current month. example
A1 = 01/01/09 and B1 has 1(month) and the answer would be 01/02/2009:
i.e.: A1-B1= 01/02/2009
thanks

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
arent you actually adding 1 to month of A1?
in your example you are expecting the result 1st feb 2009 but in the title you say you want first day of current month?

Does your region consider 01/02/2009 to be Februray 1, 2009, or January 2, 2009? Your example is mighty confusing. 1/1/09 - 1month is not 1/2/09, its 1/12/2008 isn't it?

But your words in the question equated to: "how do I determine the first day of the current month?"...but your example did not follow that question.

So, keeping in mind that regional differences with how numeric dates are read, what's the actual date your evaluating and what's your actual goal, in worded date values?

CORRECTION: A1= 01/02/09 B1= 1
i.e. A1 - B1 = 01/01/09

Actually the value of a1 is always the 1st day of the month also i.e. Jan 1, Feb 1 and so on.

=edate(a1,-b1)

that works (since the value of a1 is always the first day of the month)...thanks

Replies
2
Views
201
Replies
13
Views
737
Replies
1
Views
79
Replies
4
Views
131
Replies
3
Views
126

### Forum statistics

1,203,491
Messages
6,055,727
Members
444,814
Latest member
AutomateDifficulty

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back