Adding Columns Based on a date

On my spread sheet I enter a start date (B4) and end date (B5). Each Column from B50 onwards (date) moves by 3 months.

Is there anyway I could get the number of columns to increase automatically (With all the formulas from the previous column) based on the start and finish date, or number of columns = number of quarters (b8).

Many thanks in advance

You could use this formula in range C50 and then copy in range D50:R50 :

=DATE(YEAR(B50),MONTH(B50)+3,DAY(B50))

Regards,
Antonio

Hi Antonio

I have added that formula. But what I would like to do is avoid having to increase the number of columns i.e if I was to use 8 years vs 5 and then copy and paste all the formulas across.