Date calculation using Word 2010 table/field Syntax Error

[DavidJibson]

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.

 

[GEWB]

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

 

[jimbo45]

Hi there

You don't need to use EXCEL for this.

Here's for Word 2010
http://wordribbon.tips.net/T008660_Calculating_Dates_with_Fields.html
Cheers
jimbo

 

[GEWB]

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