View Single Post
  #4  
Old January 7th 08, 08:51 PM posted to microsoft.public.outlook
Judy Gleeson \(MVP Outlook\)
external usenet poster
 
Posts: 1,046
Default Counting Difference in # Days in MS Outlook Tasks?!

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



Ads
 

Loans - Credit Card - Car Insurance - Debt Consolidation - Credit Card Consolidation