Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

need help with calc column

  Asked By: Arnold Wall         Date: Jul 01, 2005      Category: Sharepoint      Views: 225
 

I am using the following formula in a calculated column for a list:

=MONTH([Some Date])

If the value of Some Date = '2/4/2005', the formula returns '2'. When I
go to do a "Group By," it groups my data by 1, 2, 3,...etc. How do I
set the month number to the corresponding month 'January,
February,..etc? Is there a way to do this inside my formula using an
if then or case statement? It seems doable.


Do you know someone who can help? Share a link to this thread on twitter, or facebook.

Tagged:          

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on need help with calc column Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].