automatic month column

[rjc_29]

I have a spreadsheet where a date is entered and i want a column next to it called month to automatically update to say what the month is in text format. These are then linked to a pivot table.

I don't want to have to drag the formula down each time a date is entered.

Any suggestions.

[sweep]

How about prefilling the column with a formula that displays nothing until there is data entered alongside?

eg


=IF(A1="","",TEXT(A1,"mmmm"))

[daddylonglegs]

You can use TEXT function, e.g. with date in A2

=TEXT(A2,"mmmm")

If you have your data in a list (2003) or a table (2007) then formulas will add automatically as you add data......or you can add formulas as far down as you need but make those return a blank until the date is populated, e.g. use

=TEXT(A2,"mmmm;;")

If A2 is blank you won't see anything