Microsoft Office Forums Making product labels with auto calculated expiration date

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.

[Edit by CK: Marked as solved because Paul's tutorial really does show how to do it. This is not simple stuff but it is something that can be done. For more (but not better) see Calculated Dates in Microsoft Word using Fields or vba.

If you have questions after reading the tutorial and trying it, feel free to write back. Be sure to read the introductory material in the tutorial!
Since you have posted in multiple locations, it is your job to link between them and make sure that each location knows (1) the status of your problem and (2) suggestions made elsewhere that you have tried and don't work.]

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: 19,599
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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, at:
http://windowssecrets.com/forums/sho...ation-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
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: 19,599
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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


All times are GMT -7. The time now is 11:03 AM.


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