Formula to find the first day of the previous month

[ShannP]

Hi All

I am new here and really hoping someone can help me. I am struggling to write a formula that will find the first date of the previous month.

IE today 04/5/11 therefore I need formula to return a date of 01/04/11.

All help would be greatly appreciated

 

[Ron Coderre]

It's so important to post the version of Excel that you are using because date math gets better and easier with each successive version.

With
A1: a date
If you have Excel 2007 or later, this formula returns the 1st of the previous month

B1: =EOMONTH(A1,-2)+1

Does that help?

 

[ShannP]

It's so important to post the version of Excel that you are using because date math gets better and easier with each successive version.

With
A1: a date
If you have Excel 2007 or later, this formula returns the 1st of the previous month

B1: =EOMONTH(A1,-2)+1

Does that help?

Oops my bad, I totally forgot to mention I was using 2007. And yes that is exactly what I was after