Excel question

[Neill_J]

Hi

Quick excel question

Wondered if there is a way to reference a cell containing a month entry and have follow on cells take that month data and increment by 1?

Ie.. in same way as numbers:

A1=1
A2=A1+1 = (2)
A3=A2+1 = (3)


So I am after:

A1=March
A2=A1+1 = (April)
A3=A2+1 = (May)

The value of Cell A1 could be any month dependant on my calculations, so need the follow on cells to update based on the 1st value in A1 and saves me having to manually type each cell

Cheers, Neill

 

[Kreeeee]

Set A1 as your starting date.

Set A2 as "=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))"

Format all the cells as "MMMM" and then just drag down the formula.

 

[Neill_J]

Perfect - just what I needed and its working great

Ta

 

[Kreeeee]

You're welcome