Counting Difference in # Days in MS Outlook Tasks?!

[Mark]

I am trying to Count the Difference in the # Days between:

1. The date [Created] and the [Date Completed]

and for items not completed:
2. The date [Created] and todays date.

I am working to try and add a column in the Tasks Window to show these
numbers.

Any help is greatly appreciated.

 

[Judy Gleeson \(MVP Outlook\)]

I think you should try this way:

show the fields you need in a table view. Select all of the entries, grab
and drag to a new Excel spreadsheet. Do the calculation of date differences
between two columns of dates in Excel (and no I don't know how to but it
will do it!)

Regards

Judy Gleeson
MVP Outlook
Trainer and Consultant

There are various articles about using Outlook here:
www.judygleeson.com/articles.aspx
Canberra, Australia

"What do we live for, if it is not to make life less difficult for each
other?"
George Eliot

 

[Mark]

Judy,

Thanks for your help. I did eventually realize you can copy and paste the
information into Excel.

After testing a few different things, I was finally able to create a formula
directly in a column in tasks to count the days.

Following is the Formula that seemed to work.

# of Days Since Task Created:

" Now()-[Created] "

# of Days From Date Created to Date Completed:

" [Date Completed]-[Created] "

I was then able to copy and paste to Excell and clean up the data.

Thanks for your assistance.

Mark

 

[Judy Gleeson \(MVP Outlook\)]

you're welcome - and know more about fomulae than I do!

Regards

Judy Gleeson
MVP Outlook
Trainer and Consultant

There are various articles about using Outlook here:
www.judygleeson.com/articles.aspx
Canberra, Australia

"What do we live for, if it is not to make life less difficult for each
other?"
George Eliot