Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Outlook

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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: 65
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
  #2  
Old 10-01-2011, 12:09 AM
ghumdinger ghumdinger is offline Windows 7 Office 2010 (Version 14.0)
Advanced Beginner
 
Join Date: Jul 2010
Posts: 65
ghumdinger is on a distinguished road
Default

Bump. Anyone?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't tab from field to field in form Lynieee Word 6 06-18-2012 02:37 PM
Birth Date Field in Word Form jaxibobaxi Word VBA 1 07-15-2011 07:35 PM
How to refer a field in another field DaveSmith Word 0 08-24-2010 06:44 PM
Using Field Codes to Calculate 5 years from a Date vandy Word 1 09-23-2009 11:32 AM
How to archive each month and automatically add the date to end of archive name. Phipps Outlook 0 03-11-2009 05:36 PM


All times are GMT -7. The time now is 08:47 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft