Sol Web Solutions Blog

Sol Web Solutions Blog is aimed to help, inform, educate and enable our site visitors.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Login
    Login Login form

Calculate age of SharePoint list items

Posted by on in SharePoint
  • Font size: Larger Smaller
  • Hits: 124639
  • 2 Comments
  • Subscribe to this entry
  • Print

Calculate age of SharePoint list itemEver wonder how you can calculate the age of the list items in SharePoint? The Today() function is not allowed in calculated fields, so what's the trick?

1. Go to the list where you want to calculate age of the items e.g. Task List
2. Click Settings => List Settings and create a new column and name it e.g. "Today", There is no need to select any specific type for this column (Just type the name of the column and click "OK" at the bottom)
3. Create one more column and name it e.g. "Age in Days". Select "Calculated(calculation based on other columns)" type and provide formula using "Today" column which you created in step 2 e.g. I have entered
=[Today]-[Created]. Select "number" for the data type and 0(zero) in "Number of Decimal places". So basically it will calculate difference between today’s date and date the item was created.
4. After 3rd step, remove "Today" column, which you have created in step 2. When you remove Today column, SharePoint automatically refers "Today" (which has been deleted now) as the today’s date in the formula calculation.
5. Go back to Task List and it should display the number of days under the "Age in Days" column of each items in Task List.


...thanks to Explore SharePoint @:
http://www.exploresharepoint.net

0

Comments

  • Guest
    syntax Friday, 26 September 2014

    Awesome piece of information, let me tell you, your blog gives the best and the most interesting information. once again hats off to you! Thanks a ton once again, Regards

  • Guest
    Thomas Hardin Friday, 30 January 2015

    Perfect and simple solution :) Works great in Sharepoint 365 (2013).

Leave your comment

Guest
Guest Sunday, 24 September 2017

Help Today

Send an email here!

Sol Web Solutions will be glad to help you anytime with general or technical questions, suggestions or comments.

Website Hosting

Web Hosting

Sol News

We will not share, trade, or sell any of your information in any way. Your privacy is completely respected.