Hi,



I am trying to produce a simple formula in an Word 2010 table.

Cell A1 = Date
Cell A2 = Date + 7

Is this possible?

Many thanks in advance.

Dave

Since you're looking to use formulas within the table, you'll actually need to insert a Microsoft Excel table rather than a standard Word table. You can do this by click on the drop-down triangle under the Insert Table button and selecting Excel Spreadsheet.

Once you have the spreadsheet inserted, you can insert the date by placing "=DATE(year, month, day)" in the cell (without quotes). So to put in Jan 1st, 2011, just enter "=DATE(2011,01,01)". For A2, you can either use "=DATE(2011,01,01)+7", or just "=A1+7".

Hope this helps.

Hi Dave,

Within Word:
1. table cell referencing only works for numbers, not text or dates. You can, however, bookmark the contents of a cell containing text or dates and use a cross-reference to that bookmark.
2. date maths is not as simple as taking a date and adding/subtracting another number. To see how to do just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at:
http://windowssecrets.com/forums/sho...ation-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
Do read the document's introductory material.

To see how to do a wide range of other calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Great! Thanks for both of your help!