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.

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 he
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" wrote in message
...
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,

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

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 he
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" wrote in message
...
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