Linked Date ranges

Hello,

Is it possible to have a date range display of 'April 2010 to June 2010' and then link other cells to this to show the next 3 month range? So that the formula results in 'July 2010 to September 2010'. This will allow for just updating the original cell for future changes.

Thank you,
ArtiCat

Long formula but here's one way to do what you want, put the 1st of the month for the first range in A1, e.g. 1-Apr-2010 for your example, and the number of months in each range in B1 [3] and then use this formula in C1 copied down to get successive ranges

=TEXT(DATE(YEAR($A$1),MONTH($A$1)+(ROWS(C$1:C1)-1)*($B$1),1),"mmmm yyyy")&" to "&TEXT(DATE(YEAR($A$1),MONTH($A$1)+ROWS(C$1:C1)*($B$1)-1,1),"mmmm yyyy")