You can achieve some of this by using the EOMONTH and EDATE functions. Look
on http://www.auditexcel.co.za/date.html to see how to use these functions

"Natalie" wrote:

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