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

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

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

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

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
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
Battery Calculation Error (thinkpad R51)
So, I got this old (2005-ish) laptop that was pretty new, almost unused and put 7 on it. Before I did, however, I did some benchmarking of the battery. ~3 hours to charge it from nothing, and ~40-45 minutes in the bios before it shut down, dead. Decent enough for a 5 year old battery. ...
Hardware & Devices
Forms/Word 2007/Display entire field length
Have created some basic online forms. Now I am tasked with displaying each entire field length (visually somehow) so the user can see approximately how much room they have to enter test. Examples: Name: Field length highlighted or shaded Location: Underlining would work to indicate field length...
Microsoft Office


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:01.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App