Display end of month date for previous month

I have a reporting spreadsheet that gets updated monthly and I need to have a cell display when the last report was taken in relation to the current date. i.e. if today is 6/20/2011 I need the date of report cell to say 5/31/2011 because that is the date of the most recent update.