Microsoft Office Forums Cell formulas & formatting
 User Name Remember Me? Password
 Register FAQ Search Today's Posts Mark Forums Read

 Thread Tools Display Modes
#1
04-04-2011, 09:37 AM
 kungfauxn00b Windows XP Office 2010 32bit Novice Join Date: Apr 2011 Posts: 7
Cell formulas & formatting

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
#2
04-04-2011, 04:58 PM
 Kaneto Windows 7 Office 2010 (Version 14.0) Competent Performer Join Date: Nov 2010 Posts: 136

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.
#3
04-04-2011, 08:03 PM
 macropod Windows 7 32bit Office 2000 Administrator Join Date: Dec 2010 Location: Canberra, Australia Posts: 21,929

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]
#4
04-05-2011, 04:54 AM
 kungfauxn00b Windows XP Office 2010 32bit Novice Join Date: Apr 2011 Posts: 7

Great! Thanks for both of your help!

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post furface00 Excel 5 02-27-2011 02:22 PM Learner7 Excel 0 07-08-2010 05:50 AM Scaffold Excel 2 05-01-2010 08:56 AM Niko Excel 5 04-23-2009 12:05 AM dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:48 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft