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.
How about prefilling the column with a formula that displays nothing until there is data entered alongside?
eg
=IF(A1="","",TEXT(A1,"mmmm"))
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
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
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks