How to get the date of 3 months ago from today?

Hello Sir,

I have to figure out the date of 3 months ago from today. The rule is:

1) if today is the month end (e.g. 30/06/2013), then 3 months ago will also be the month end (e.g. 31/03/2013).

2) if today is not the month end (e.g. 10/06/2013), then 3 months ago will have the same day (e.g. 10/03/2013). But this has some exceptional case, because some month has 30th while other month does not. For example, if today is 30/05/2013, then 3 months ago will be in February which does not have 30th. In this case, just make it as the month end of 3 months ago.

Thanks, Fotis1991. Based on yours, I made it as:

=IF(A1=EOMONTH(A1,0),DATE(YEAR(A1),MONTH(A1)-2,),EDATE(A1,-3))

If the month is 30/04/2013, then I want the 3 months ago to be 31/01/2013 which is also the month end.