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
DavidJibson

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
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

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
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

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
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

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
Thread Forum
Multiple Macro field in Word on every page
Hello, I need to put into the Word a filed on each page, where only first field will be filled with the data and it will be copid automatically to the another field on each page. e.g. I have a field on page 1,2,3,4,5. I will put a number into the field on the page 1 and fields on the pages...
Microsoft Office
date modification field does not change
hi, i searched in vain for an answer to this question: when i edit an image file and resave, the date modified date does not change. since i started using computers 100s of years ago, this was automatic. how can i enable this (obvious) field? what point is there in even having a date modified...
General Discussion
Weird behavior by Windows 7, clock/date field changing
I am furious at not knowing why my date/clock in Windows 7 keep changins its appearance. It is as if the files or settings for Windows change mysteriously back and forth and I don't like it one bit. The issue pertains to this clock/date shown at the bottom right corner on the screen just beside...
General Discussion
Create a Date macro Word 2010
I'm having trouble creating a macro to insert the current date (static). Here's what I'm doing: View > Macros > Record Name: "Date" Store macro in: keyboard Shortcuts Click on keyboard picture Insert: CRTL+D & click Assign
Microsoft Office
Is there a way to edit the time in DATE TAKEN field?
I can't seem to edit the time but I can change the date on images, is there a work around?
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 17:38.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App