Diane Poremsky
Senior Member
- Outlook version
- Outlook 2016 32 bit
- Email Account
- Office 365 Exchange
Diane Poremsky submitted a new article on Slipstick.com
Calculate Days Overdue and Days to Complete Tasks
Calculate Days Overdue and Days to Complete Tasks
Continue reading the Original Article at Slipstick.comIs there a way to report on tasks - time overdue, number of times job extended from original date, average time for completion per category of task for individual users etc.
Outlook doesn't track extensions and date changes, but you can view the number days overdue and days to complete each task using custom fields.
![]()
For this we combine the IIF and DateDiff functions:
Iff(expression, do if true,...