1

I have a calculated column that calculates today date dynamically

I followed this link

problem is calculated column in number data type. I want it as Date and Time date format.

I want to calculate date difference between dynamic today date and another Overdue date field.

Can you help me please...

Mohamed El-Qassas MVP
  • 45,382
  • 9
  • 53
  • 96
Manikandan
  • 11
  • 1
  • 4
  • You can try as mentioned in this link: https://sharepoint.stackexchange.com/questions/171222/count-not-updating-in-calculated-column/171482#171482 – Dikesh Gandhi Oct 06 '17 at 06:34

1 Answers1

2

First, you should be aware of the output of the two date difference should be in Days or Months or Years as a Number!

If you set The data type returned from this formula as DateTime, it would work but it logically would show invalid data.

enter image description here

So the difference should be shown as Number Not as Date format!

To get the diff between today and overdue date through this calculated column formula 

=DATEDIF([overdue date],TODAY(),"d")

enter image description here

Note:

The calculated column formula is only calculated/updated in the following cases:

  • Add New Item.
  • Update Existing item.
  • Update the calculated column itself in the List Setting!

Check Also

To update the calculated column daily

Try to Create a Retention Policy to run a workflow which updates the list items daily!!

Or instead of using calculated column, use JSlink as mentioned at Days Past Since List Item Created - SharePoint Online 2013

Mohamed El-Qassas MVP
  • 45,382
  • 9
  • 53
  • 96