Sla countdown in SP using todays date minus expected date.

Hi Kidbaybut,

to try calculate the SLA countdown in SharePoint using today's date minus the expected date, including negative values when the expected date is in the past, you can use the following formula:

=IF([Expected Date] >= TODAY(), [Expected Date] - TODAY(), -(TODAY() - [Expected Date]))

This formula should give you the number of days left (positive) if the expected date is in the future or today, and it should show how many days overdue (negative) you are if the expected date is in the past.