Wednesday, June 18, 2008

Formula to display Month Name from the Date in calculated column in sharepoint

=IF(MONTH([Confidentiality Period])=1,"January","")&IF(MONTH([Confidentiality Period])=2,"February","")&IF(MONTH([Confidentiality Period])=3,"March","")&IF(MONTH([Confidentiality Period])=4,"April","")&IF(MONTH([Confidentiality Period])=5,"May","")&IF(MONTH([Confidentiality Period])=6,"June","")&IF(MONTH([Confidentiality Period])=7,"July","")&IF(MONTH([Confidentiality Period])=8,"August","")&IF(MONTH([Confidentiality Period])=9,"September","")&IF(MONTH([Confidentiality Period])=10,"October","")&IF(MONTH([Confidentiality Period])=11,"November","")&IF(MONTH([Confidentiality Period])=12,"December",""))

In the above formula [Confidentiality Period] is a column of data type "Date and Time".

No comments: