Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
Reply



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 08:46 PM.


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