Calculate Days Overdue and Days to Complete Tasks

Not open for further replies.

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Diane Poremsky submitted a new article on

Calculate Days Overdue and Days to Complete Tasks

Is 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,...
Continue reading the Original Article at
Not open for further replies.
Thread starter Similar threads Forum Replies Date
ThinkToday Calculate reply time of outlook mail Using Outlook 1
H Calculate the Response time of a thread Outlook VBA and Custom Forms 3
M Moving mailboxes from Exchange 2003 to 2010 - how to calculate move request batch size? Exchange Server Administration 3
W How do I calculate the next recurrence date? Outlook VBA and Custom Forms 1
F Automatically calculate age from birthdate Outlook VBA and Custom Forms 2
C How to use VBA to show only items x days old or more Outlook VBA and Custom Forms 1
TomHuckstep Outlook 2016 Limit the number of days syncing from Google Calendar Using Outlook 1
cricket1001 Shade non-working days in calendar Using Outlook 0
M How many days are items in Recover Deleted at ? Using accounts in Outlook 4
S Mail filter recieved before the last 2 working days Using Outlook 1
copperberry How to display incomplete tasks due on or before 7 days from now Using Outlook 0
Diane Poremsky Booking meetings more than 180 days out New Articles 1
Commodore Finding items from last 7 days Using Outlook 2
P printing weekly calendar in Outlook 2013 cuts days of week off Using Outlook 1
A reminder for every 15 working days Using Outlook 11
N To do bar - show more than 30 days of appointments Using Outlook 0
H Move outlook emails >90 days to shared drive (Desktop) Folder Outlook VBA and Custom Forms 5
F Recurring meeting with recurring prep. 2 days before Using Outlook 1
D Make Days "Bolder" in Side Calendars? Using Outlook 1
J Outlook Mailbox cleanup; any way to change limit to find items older 999 days? Exchange Server Administration 2
R Rules - apply to messages > n days old Using Outlook 2
Y Search/list all emails sent between 6pm to 12am in the past 30 days Using Outlook 3
K Automate permamnent delete after x days with exceptions Using Outlook 1
M Using remove from server after x days Using Outlook 7
T A 2nd appt xxx days after the 1st Using Outlook 1
M How to forward a message and delay sending for up to 30 days Using Outlook 8
J Print next 7 days view of calendar (2010) Using Outlook 3
C does unchecking "remove from server after 14 days" cancel removal Using Outlook 2
R printing custom number of calendar days in weekly view format Using Outlook 1
F Outlook Re-Downloading RSS Feed Posts Days Later Using Outlook 3
A Days of the year Using Outlook 5
J Macro to move mail from Inbox if older than 4 days Using Outlook 4
E Next five calendar days Calendar Printing Assistant 2
C Selecting days in business notes BCM (Business Contact Manager) 0
P Task view - due next 21 days Using Outlook 1
P exchange management consoles has stoped working and yes I have read the above article and tried the troubleshooter and spent days reading and trying d Exchange Server Administration 0
J Outlook changing from inbox/trash/sent, etc. is EXTREMELY slow since updating Windows a couple of days ago. Is there an issue with Outlook as to the Using Outlook 2
D Exchange 2010 SP1 Policy to Delete mail in deleted items older than 30 days Exchange Server Administration 2
A Outlook 2010 - Favorites disappear after a couple of days Using Outlook 2
S Exchange 2010 OWA Search only returns 2 days worth Using Outlook 2
P Outlook deletes email after 7 days from inbox only Using Outlook 6
L 30 days' worth of emails are gone in Outlook Express; cannot be found anywhere. Is there anyway I can retrieve them? Any help would be appreciated. Using Outlook 1
R Emails show up 2 or 3 days late. Using Outlook 4
S Outlook 2003 cannot delete LARGE msg in outbox - 2 days Using Outlook 2
M Exchange 2010 does not updat GAL since few days Exchange Server Administration 28
F number of messages older than X number of days Exchange Server Administration 3
J Outlook 2007 Reminders show up 6 days in advance when set for 30 minutes. Using W7. Using Outlook 2
S license 120 days Exchange Server Administration 2
S 4 days can not access email, message is 'can not start microsoft office outlook....' Using Outlook 1
Similar threads