Is there a way to have Excel return 3 different dates in reference to Today (
):

eg. Today = 7/15/05

1. last calendar day of this month
2. last calendar of this quarter
3. 15th of this month or last calendar date, which ever is earlier

Thank you