months

[drchit]

i want to construct a table where the months look like this...

5/18/02
6/18/02 and so on for two years, but i can't seem to drag the formula down. do i have to physically type the values into the formula or is there an alternative, thanks!

 

[Mudface]

Try right-clicking and dragging then choose the Fill Months option from the pop-up. HTH.

 

[Aladin Akyurek]

On 2002-08-29 00:44, drchit wrote:
i want to construct a table where the months look like this...

5/18/02
6/18/02 and so on for two years, but i can't seem to drag the formula down. do i have to physically type the values into the formula or is there an alternative, thanks!

In A1 enter: 5/18/02

In A2 enter one of & copy down:

=EDATE(A1,1)

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))