column B will automatically populate the month depending on the date in column A

**Elainefish** · 04-10-2014, 04:22 AM

If column A will be column for dates, I want B to automatically pupulate the month in the column B. I need it as text, not number because I will concatenate the data

for ex:

25-01-2010 = jan
25-08-2011 = aug

**ragulduy** · 04-10-2014, 04:29 AM

=TEXT(A1,"mmm")

column B will automatically populate the month depending on the date in column A

LinkBack

Thread Tools

Rate This Thread

Display

column B will automatically populate the month depending on the date in column A

Re: column B will automatically populate the month depending on the date in column A

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Populate a column depending on the contents of other sheets.

Automatically pop up a number in column B depending on the text from column A

[SOLVED] Macro to update the date column for certain rows in a table depending on a column value

Need to automatically insert dollar amount in the column depending on the city in column A

[SOLVED] Fill column with dates of month depending on month in A1

Bookmarks

Bookmarks

Posting Permissions