COnverting Weeks into Month (text data)

A

azabita

In one column, I have all my week data, for example 11/4/2011, 3/2/2012
5/18/2012, etc for all the weeks that have transpired since Nov 1
2011.

I want to convert this column into months, so if a week was 11/4/2011,
want it to read Nov; if 3/2/2012, March, and so on and so forth.

Is there a formula that can help me?
All data (MM/DD/YYYY) is in one single colum
 
I

isabelle

hi azabita,

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


--
isabelle




Le 2012-06-08 09:19, azabita a écrit :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top