Round to previous quarter end

I have in Cell A1: =Today()
I would like Cell B1 to equal the most recent quarter end date.

Any ideas? Thanks

So I presume that means you want to show 31st March, 30th June, 30th sept or 31st December?

Try this formula to always show the end date of the previous quarter

=DATE(YEAR(A1),FLOOR(MONTH(A1)-1,3)+1,0)

Note: on a date that is actually a quarter end date, e.g. 30th June 2007 this will still show the end date of the previous quarter, 31st March. If you don't want that you could tweak it like this

=DATE(YEAR(A1+1),FLOOR(MONTH(A1+1)-1,3)+1,0)