How do I add formulas to outlook tasks?

[TMoye]

I am setting up my tasker log and would like to have formulas to
automatically calcullate due dates.

 

[Sue Mosher [MVP-Outlook]]

Calculate due dates based on what information?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[TMoye]

Due dates for projects that I am working on, i.e. project A is due in 120
days/4 months. And within that, I need a formula to show me what date is the
half way mark so I can ensure I'm on track.

 

[Sue Mosher [MVP-Outlook]]

So you want a formula that -- at the time you save the task -- can calculate the date that falls halfway between today's date and the due date?

This formula for use in a formula field takes half the difference between the date the task was created and its due date and adds that to the created date:

DateAdd("d",CInt(DateDiff("d",[Created],[Due Date])/2),[Created])

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers