Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Date calculation using Word 2010 table/field Syntax Error


22 Jul 2013   #1

Windows 7 Pro x64
 
 
Date calculation using Word 2010 table/field Syntax Error

I have a Word 2010 document and I want to have specific text appear if a date is more than 42 days away from today (whatever today happens to be). I've got a three-cell table that looks like:


________________________________________________________

| DATE: | 12/25/13 | { =IF(B1-TODAY()>42,TRUE,FALSE) } |
________________________________________________________



I keep getting a Syntax Error on my field in the 3rd cell. I think the problem is that Word doesn't understand "TODAY()" like Excel does, but I don't know if there is any other way to calculate the days between two dates? My eternal gratitude to anyone who can figure out how to do this properly.


My System SpecsSystem Spec
.

22 Jul 2013   #2

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

You will need to create a spreadsheet then "Link" that spreadsheet containing the calc cells.

Things to Remember When Linking
  • If you move the linked Excel file, you break the link. To fix this, you need to relink the file.
  • Double-click on the Excel data in your document to edit it: this opens the linked spreadsheet.
  • You can also edit the spreadsheet directly: the changes appear in your Word document once you save the Excel spreadsheet.
Regards,
GEWB
My System SpecsSystem Spec
23 Jul 2013   #3

W7 X-64 W8.1 X-64 Opensuse 13.1 W2003 Server
 
 

Hi there

You don't need to use EXCEL for this.

Here's for Word 2010
http://wordribbon.tips.net/T008660_C...th_Fields.html
Cheers
jimbo
My System SpecsSystem Spec
.


24 Jul 2013   #4

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

Quote   Quote: Originally Posted by jimbo45 View Post
Hi there

You don't need to use EXCEL for this.

Here's for Word 2010
Calculating Dates with Fields (Microsoft Word)
Cheers
jimbo
+1 for jimbo - I had forgotten to check my WordTips subscription! (There is also an ExcelTips from the same author.)

Regards,
GEWB
My System SpecsSystem Spec
Reply

 Date calculation using Word 2010 table/field Syntax Error




Thread Tools



Similar help and support threads for2: Date calculation using Word 2010 table/field Syntax Error
Thread Forum
date modification field does not change General Discussion
Weird behavior by Windows 7, clock/date field changing General Discussion
Solved Create a Date macro Word 2010 Microsoft Office
Is there a way to edit the time in DATE TAKEN field? Music, Pictures & Video

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 11:06 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33