Consider todays date in cell A1, then use:

1. last calendar day of this month
=DATE(YEAR(A1),MONTH(A1)+1,1)-1


2. last calendar of this quarter
=DATE(YEAR(A1),ROUNDUP(MONTH(A1)/3,0)*3+1,1)-1


3. 15th of this month or last calendar date, which ever is earlier
=IF(DAY(A1)<=15,DATE(YEAR(A1),MONTH(A1),15),DATE(Y EAR(A1),ROUNDUP(MONTH(A1)/
3,0)*3+1,1)-1)


Mangesh



"Natalie" wrote in message
...
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