Calculate Days Overdue and Days to Complete Tasks

Not open for further replies.

Diane Poremsky

Senior Member
OS Version(s)
  1. MacOS
  2. Windows
  3. iOS
  4. Android
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.
Similar threads
Thread starter Title 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
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
e_a_g_l_e_p_i Is it possible to have a reminder in Outlook 2021 for every 90 days Using Outlook 3
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 Using Outlook 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 Using Outlook 2
C Selecting days in business notes BCM (Business Contact Manager) 0
P Task view - due next 21 days Using Outlook 1
P Outlook deletes email after 7 days from inbox only Using Outlook 6
C send mail every days Outlook VBA and Custom Forms 7
M Stop Search folders from disabling every 1-2 days? Outlook VBA and Custom Forms 3
B How to create the customized Outlook SQL DASL for selected days? Outlook VBA and Custom Forms 2
I Outlook Rules based on number of days Outlook VBA and Custom Forms 6
M Outlook - Search Criteria for Overdue Appointments Using Outlook 3

Similar threads