Forum Discussion
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.
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.
If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic