View Single Post
  #1   Report Post  
azabita azabita is offline
Junior Member
 
Posts: 1
Default COnverting Weeks into Month (text data)

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, I 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 column