What is calculated column in SharePoint 2013 ,2010

Hi Guys,

Thanks for visiting my blog .

While creating  Columns in Custom List  many of us have seen the Calculated  Column .

I will describe the calculated column for Month and year .

Go to the list settings and then click on Create column to add a new column. Give the column name and chose the column type as calculated column. Then in the formula write like below:

=TEXT([Created],"yyyy")

he above formula will return the formula as a single line text, Now if you want to return as integer then you can write the formula like below:

=YEAR(Created)

Similarly

 if you want to store month then follow the above step and write the formula like below:

=Text(Created, "MMMM") : This will return the full month name

=Text(Created, "MMM") : This will return first 3 letters of the month name

=Text(Created, "MM") : This will return integer month

If you want to return the value as an integer then you can write the formula like below:

=MONTH(Created)

Now if you will check the output will come like above :

Related Post

SharePoint 2010

• List view render using JSLink with Fabric UI
• Delete Quick Links using Powershell
• delete/Add Top Navigation Links using Powershell
• PowerShell::Get Content Database Size in SharePoint
• PowerShell :: Delete All List Items
• Basics: Difference between Synchronous Events and Asynchronous Events in SharePoint
• Remove-SPSite 0x80070003 - Forcely delete Site Collection that cannot be deleted
• This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server to read from the configuration database. To connect this server to the server farm, use the SharePoint Products Configuration Wizard, located on the Start menu in Microsoft SharePoint 2010 Products.
• Restore-SPSite: The operation that you are attempting to perform cannot be completed successfully.
• Get List Field Type using ECMA Script in SP Hosted Apps
• SharePoint Interview Questions and Answers..
• What are Event Receivers and How to Create Sample event Receivers and attach to List/ Doc Library ?
• Export SharePoint Search Crawl log to CSV File.
• Create Content Type using ECMA Script
• Get List Content Types using ECMA Script
• SharePoint Modal Dailoge to Open Page
• SPDataSource in SharePoint.
• Capacity planning and Sizing in SharePoint 2010
• Enable 'Save site as Template' in Publishing Sites by using SharePoint Designer
• Read Enhanced Rich Text Values in SharePoint
• What is Web part life Cycle in SharePoint 2013 and SharePoint 2010
• How to Hide Controls in SharePoint New Form Based on User using ECMA Script.
• What is the Content Type for Custom List in SharePoint 2013, SharePoint 2010
• Create Meetings by using Exchange Server API

SharePoint 2013

• List view render using JSLink with Fabric UI
• Delete Quick Links using Powershell
• delete/Add Top Navigation Links using Powershell
• Get CheckedOut Files from SharePoint 2013 and MOSS2007
• PowerShell::Get Content Database Size in SharePoint
• PowerShell :: Delete All List Items
• Powershell :: Apply Master Page to all sub sites under site collection
• Internet Explorer cannot display this feed - while accessing REST URL in SharePoint
• SharePoint Installation: The tool was unable to install application server role web server (IIS) role SharePoint 2013.
• Basics: Difference between Synchronous Events and Asynchronous Events in SharePoint
• Remove-SPSite 0x80070003 - Forcely delete Site Collection that cannot be deleted
• This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server to read from the configuration database. To connect this server to the server farm, use the SharePoint Products Configuration Wizard, located on the Start menu in Microsoft SharePoint 2010 Products.
• Restore-SPSite: The operation that you are attempting to perform cannot be completed successfully.
• Migrate Multiple site(sub sites) using MetaLogix and change the Template in Target
• Issue:The date file "C:\ProgramData\Metalogix\EnvironmentSettings.xml" contains invalid data.Values in that file reset to defaults
• Get List Field Type using ECMA Script in SP Hosted Apps
• SharePoint Interview Questions and Answers..
• Issues:SharePoint Foundation 2013 Prerequisites installation(off line) on Windows Server2012 R2
• Get Choice Field Type Values using ECMA Script
• Something Went wrong error message while deploying App in SharePoint 2013
• The Server was unable to save the form at this time. Please try again.
• Get the Items inside the Folder in document Library in SharePoint 2013 using REST API
• SharePoint Client Browser for SharePoint Online and SharePoint On-Premises
• What is Managed meta data service in SharePoint 2010, 2013 and How to Configure it?
• Deprecated features in SharePoint 2013