How do I make a sharepoint formula that calculates date different based on when a value was last entered

Question

Here's the problem I'm trying to solve. I have an Infopath form that users fill out and submit to a SharePoint library, and every field on the form is mapped to a SharePoint column.

Column A will have the name of a department, and column B will have the date that an occurrence was submitted on that department. There are several departments to choose from. I need to make a calculated column (column C) that will show how many days its been since an occurrence was reported on a specific unit.

Data will be set up like this:

A      B            C
1 South 4/20/2013   0
2 East  4/15/2013   8
3 South 4/18/2013   5
1 South 4/23/2013   0

C should calculate the amount of days since the last occurrence was reported for a specific unit. Assuming the current date is 4/23/13, column C should so the following values for each unit. 1 South would be 0 since there was an occurrence reported on the current day.

lem.mallari lem.mallari · Accepted Answer · 2013-04-23T19:48:22

You can create a calculated column and use [Today] and subtract it from the value of column B. So you can implement like below:

=DATEDIF([B], [Today],"d")

This will return the number of days between a column named "B" and today's date.

If you're interested on creating other formula for calculated fields you can check them out in more detail here.

How do I make a sharepoint formula that calculates date different based on when a value was last entered

3 Answers