View Single Post
 
Old 09-27-2011, 11:59 PM
ghumdinger ghumdinger is offline Windows 7 Office 2010 (Version 14.0)
Advanced Beginner
 
Join Date: Jul 2010
Posts: 64
ghumdinger is on a distinguished road
Default Formula to subtract one month from due date field in reminder field

I have a custom form for a particular group of tasks. I am try to set the reminder field to be calculated automatically, using a formula which subtracts one month from the due date field:

=EDATE("[Due Date]",-1)

I can't find much on outlook formulas online, so I tried this excel formula. It doesn't work and gives the same value for different due date values.

Would appreciate suggestions!

Thanks,
Jay
Reply With Quote