Calc Date Based on Year

[Johnny]

I need a formula that calculates the end date of each calendar quater based
on the year. For example, if the year in A1 = 2009 then the dates in A2
through A5 should be 1/31/09, 4/30/09, 7/31/09 & 10/31/09 respectively. When
I change A1 to 2010, I need the dates to reflect 2010 dates. I would also
need the formulat to account for leap years if possible.

Thank you

 

[Gary''s Student]

In A2 thru A5:

=DATE(A1,1,31)
=DATE(A1,4,30)
=DATE(A1,7,31)
=DATE(A1,10,31)

 

[Bob Phillips]

Use

=DATE(2009,ROW(A1)*3+1,0)

and copy down 4 cells

 

[Johnny]

Thank you. Just what I needed. I'll make sure to post feedback.