Microsoft Office Forums Formula to subtract one month from due date field in reminder field

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-27-2011, 11:59 PM
ghumdinger ghumdinger is offline Formula to subtract one month from due date field in reminder field Windows 7 Formula to subtract one month from due date field in reminder field Office 2010 (Version 14.0)
Advanced Beginner
Formula to subtract one month from due date field in reminder field
 
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 Formula to subtract one month from due date field in reminder field Windows 7 Formula to subtract one month from due date field in reminder field Office 2010 (Version 14.0)
Advanced Beginner
Formula to subtract one month from due date field in reminder field
 
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
Formula to subtract one month from due date field in reminder field Can't tab from field to field in form Lynieee Word 6 06-18-2012 02:37 PM
Formula to subtract one month from due date field in reminder field 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
Formula to subtract one month from due date field in reminder field 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 11:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft