Physical year

[seanrigby]

i have a physical year that starts April 1st and ends on march 31st of the following year.

Based on this, I'd like to list the particular year, and have it come back with the physical start date and end date for each quarter of the physical year.

For example: if I choose 2009, the start date would be 04/01/09 and the end date is 06/30/09, but if i choose 2010, the start date would be 04/01/10 and end date would be 06/30/10.

How do I make a formula to be able to tell the exact dates?

Based on this result, I can make a formulas for dates to fall between those dates.

[DonkeyOte]

For sake of demo assume A1 contains Fiscal Year be it 2009, 2010 etc

Q1 Start & End
A2 : =DATE($A$1,4,1)
B2 : =DATE($A$1,6,30)

I suspect from the above you can deduce the remainder.