Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-04-2011, 09:37 AM
kungfauxn00b kungfauxn00b is offline Cell formulas & formatting Windows XP Cell formulas & formatting Office 2010 32bit
Novice
Cell formulas & formatting
 
Join Date: Apr 2011
Posts: 7
kungfauxn00b is on a distinguished road
Question 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
Reply With Quote
  #2  
Old 04-04-2011, 04:58 PM
Kaneto Kaneto is offline Cell formulas & formatting Windows 7 Cell formulas & formatting Office 2010 (Version 14.0)
Competent Performer
 
Join Date: Nov 2010
Posts: 136
Kaneto is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 04-04-2011, 08:03 PM
macropod's Avatar
macropod macropod is offline Cell formulas & formatting Windows 7 32bit Cell formulas & formatting Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,225
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
  #4  
Old 04-05-2011, 04:54 AM
kungfauxn00b kungfauxn00b is offline Cell formulas & formatting Windows XP Cell formulas & formatting Office 2010 32bit
Novice
Cell formulas & formatting
 
Join Date: Apr 2011
Posts: 7
kungfauxn00b is on a distinguished road
Default

Great! Thanks for both of your help!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell formulas & formatting Protecting the formatting and formulas in a worksheet furface00 Excel 5 02-27-2011 02:22 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM
Cell formulas & formatting Conditional formatting of cell, Excel 2003 Scaffold Excel 2 05-01-2010 08:56 AM
Cell formulas & formatting Cell formatting Niko Excel 5 04-23-2009 12:05 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:46 PM.


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