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
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
=TEXT(A1,"mmm")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks