Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-19-2010, 05:54 AM
HoresXB HoresXB is offline Date Formatting in MS word 2007 Windows XP Date Formatting in MS word 2007 Office 2003
Novice
 
Join Date: Jan 2010
Posts: 2
HoresXB is on a distinguished road
Default Try this

You need 2 modifications:
1. use QUOTE to introduce something into another function
2. consider Jan=1, your formula generates zero, an invalid number for month


{QUOTE "1-{=MOD({DATE \@ "M"}+10,12)+1}-1" \@ "MMMM"}

note:
in the primary structure


{QUITE "d-m-y" \@ "MMMM"}
where "d-m-y" is a necessary parameter; you have to **create** a valid date. All you concern is the operation of month, therefore both day and year could be any number you like.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2003 formatting help please! rust1477 Word 0 11-11-2009 06:28 PM
Date Formatting in MS word 2007 Inserting Date, formatting to superscript and subscript louq Word 1 10-22-2009 09:29 AM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
Date Formatting in MS word 2007 Word Formatting Peter B. Word 5 05-10-2006 08:13 AM
Date Formatting in MS word 2007 Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:43 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