Calculated Column with DATEDIF

Hi Miguel_Lujan,

The reason for the varying values in the "DaysLeft4Due" column is likely due to the way SharePoint handles the calculation and updates of calculated columns.

SharePoint calculated columns are not automatically updated in real-time for all items in the list. Instead, they get updated or recalculated when the item is created or modified. So, if you have multiple items with the same Due Date, the "DaysLeft4Due" value might not be the same for all of them, especially if the "Today()" function doesn't update simultaneously for all items.

Let me try to explain it in simpler terms:
When an item is created or modified, SharePoint calculates the "DaysLeft4Due" for that specific item using the "Due date" and the current date at that moment. However, since other items in the list might have been created or modified at different times, their "Today()" value may differ, resulting in slightly different "DaysLeft4Due" values even for the same Due Date.

If two items have the same Due Date, but one was created a day before the other, their "Today()" value would be different, and that leads to different "DaysLeft4Due" values.