Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2017, 12:12 AM
adrianppa adrianppa is offline Making product labels with auto calculated expiration date Windows 10 Making product labels with auto calculated expiration date Office 2016
Novice
Making product labels with auto calculated expiration date
 
Join Date: Apr 2017
Posts: 1
adrianppa is on a distinguished road
Default Making product labels with auto calculated expiration date

Hello,



I'm trying to help a friend make a Word document to print labels for products with expiration date. I made a table with two columns and 10 rows, and i inserted the label design as an image in each table cell. In each cell i inserted a small text box where the actual expiration date should show. Now i need a way to auto insert the expiration date in each text box (expiration date is 14 days from today). I tried using date field and adding 14 days to it but i can't make it work.
Any help would be appreciated.

Last edited by Charles Kenyon; 04-07-2017 at 05:11 PM. Reason: Mark as solved
Reply With Quote
  #2  
Old 04-07-2017, 12:41 AM
macropod's Avatar
macropod macropod is offline Making product labels with auto calculated expiration date Windows 7 64bit Making product labels with auto calculated expiration date Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,322
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

The field coding for this is rather more complex than just taking a DATE field's value and adding 14. To see how to do this and just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial in the 'Sticky' thread at the top of this forum:
Microsoft Word Date Calculation Tutorial
In particular, look at the item titled Calculate a day, date, month and year, using n days delay. Do read the document's introductory material.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 04-07-2017, 12:46 AM
macropod's Avatar
macropod macropod is offline Making product labels with auto calculated expiration date Windows 7 64bit Making product labels with auto calculated expiration date Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,322
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

Cross-posted at: https://answers.microsoft.com/en-us/...1-185ee37b782b
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making product labels with auto calculated expiration date How can I automate the mail merge process in word for making labels using the 5160 Avery template? zrobles Mail Merge 5 08-07-2015 02:07 AM
Need help making labels from Single Column Word file of addresses genoMU69 Mail Merge 1 06-26-2014 03:33 PM
Making product labels with auto calculated expiration date Inserting a date calculated from a table cell theMikeD Word 2 09-11-2012 05:46 PM
Sum Product Multiple Text and date Criteria ramki Excel 1 01-09-2012 01:16 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 08:59 AM.


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