Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 07-11-2016, 09:27 AM
Charles Kenyon Charles Kenyon is online now Date Function Windows 8 Date Function Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,591
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by breen77 View Post
sorry i need it to give customer as i said previous

if i issue letter today 11 July 2016 i want retunr by 11 August 2016??
In the example you are giving, one month and 31 days are the same.



If you issue the letter on September 11, do you want a response by October 11 (one month) or by October 12 (31 days)? The code would be different.
Reply With Quote
  #17  
Old 07-11-2016, 09:52 AM
breen77 breen77 is offline Date Function Windows 8 Date Function Office 2010 32bit
Novice
Date Function
 
Join Date: Jul 2016
Posts: 24
breen77 is on a distinguished road
Default

Sorry Charles I want the letter to read one month as in 28 January response by 28 February
Reply With Quote
  #18  
Old 07-11-2016, 12:21 PM
Charles Kenyon Charles Kenyon is online now Date Function Windows 8 Date Function Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,591
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

And, you want this date from the date you create the letter from your template? You are not going to write the letter, sit on it a few days or a weekend and then send it?
Reply With Quote
  #19  
Old 07-11-2016, 12:41 PM
Charles Kenyon Charles Kenyon is online now Date Function Windows 8 Date Function Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,591
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Attached is a document, with fields taken from Paul's tutorial. One will give a date a month out in a system with regional settings set for dates formatted Month-Day-Year. The other with them formatted for Day-Month-Year. These are set to go in a template that you use to create your letter and are based upon the creation date for the new letter.

I would again urge you to read Paul's tutorial, especially the introductory portions. You can review the actual field by pressing Alt+F9.
Attached Files
File Type: docx deleteme.docx (31.9 KB, 13 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel day date month year Function greginky Excel 1 01-05-2016 02:19 AM
Excel date or edate function help JohanB26 Excel 2 07-17-2013 09:23 AM
If Function Challenge involving date no1texan Excel 6 07-15-2012 12:58 PM
Date Function Today's Date Function freschij Excel 3 02-11-2011 10:21 AM
Date Function in word? aligahk06 Word 1 04-21-2010 06:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:01 AM.


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