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.

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

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

jimbo45 said:

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