Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2018, 11:18 AM
arojo1976 arojo1976 is offline Calculating age on a Word Document Windows 7 64bit Calculating age on a Word Document Office 2013
Novice
Calculating age on a Word Document
 
Join Date: Oct 2018
Posts: 4
arojo1976 is on a distinguished road
Default Calculating age on a Word Document

I am updating a Word document and I would like to do the following:
1. Calculate age
2. When a Referred From is selected (using a drop menu) that the Referral Code populates with the correct code.



I've tried to read and insert formulas but I am still not getting the results I want. I am not a developer but I love creating forms and if I can make this user friendly for my clinical staff, even better. I have attached the Word document I am working on.

Please help
Attached Files
File Type: docx DRAFT - crisis evaluation.docx (38.5 KB, 29 views)
Reply With Quote
  #2  
Old 10-04-2018, 01:30 PM
macropod's Avatar
macropod macropod is offline Calculating age on a Word Document Windows 7 64bit Calculating age on a Word Document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

To see how to do the age calculation and just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at the top of this forum:
https://www.msofficeforums.com/word/...-tutorial.html
In particular, look at the item titled Interactively Calculate A Person’s Age. Do read the document's introductory material.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-04-2018, 01:54 PM
arojo1976 arojo1976 is offline Calculating age on a Word Document Windows 7 64bit Calculating age on a Word Document Office 2013
Novice
Calculating age on a Word Document
 
Join Date: Oct 2018
Posts: 4
arojo1976 is on a distinguished road
Default

I'm sorry but I still don't understand. What is the formula to use. I've read the zip file but I don't understand it.
Reply With Quote
  #4  
Old 10-04-2018, 02:17 PM
macropod's Avatar
macropod macropod is offline Calculating age on a Word Document Windows 7 64bit Calculating age on a Word Document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

My previous reply said:
Quote:
Do read the document's introductory material.
Did you do that?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-04-2018, 03:10 PM
arojo1976 arojo1976 is offline Calculating age on a Word Document Windows 7 64bit Calculating age on a Word Document Office 2013
Novice
Calculating age on a Word Document
 
Join Date: Oct 2018
Posts: 4
arojo1976 is on a distinguished road
Default

Yes I did do that. I still don't understand. Like I mentuioned before, I am not a developer. I am not advanced in Microsoft. I kno e the basics and play around with the rest.
Reply With Quote
  #6  
Old 10-04-2018, 03:21 PM
macropod's Avatar
macropod macropod is offline Calculating age on a Word Document Windows 7 64bit Calculating age on a Word Document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

This has nothing to do with whether you're a developer, but everything to do with whether you can follow a few simple instructions.

As clearly stated under the tutorial sub-heading Using the Tutorial’s Fields in Your Own Documents, implementation requires little more than copying the second field code under the Interactively Calculate A Person’s Age heading from the tutorial into your own document, then changing the 'BirthDate' references there to your 'DOB' reference, or vice versa. Of course, it would also help if the typed birth date in your document was actually in a formfield…

PS: I note that your document contains both content controls and formfields. You should not use both in the same document; they were not designed to be used that way and doing so is a known source of problems.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 10-04-2018, 04:36 PM
arojo1976 arojo1976 is offline Calculating age on a Word Document Windows 7 64bit Calculating age on a Word Document Office 2013
Novice
Calculating age on a Word Document
 
Join Date: Oct 2018
Posts: 4
arojo1976 is on a distinguished road
Default

It's not that I can not follow the instructions. I just don't know where to look on the tabs and what goes where. Your tone that came thru was a bit rude. All I am asking is guidance - step by step tutorial. You mentioned content controls and formfields - I don't know what you are talking about. I will ask my Information Systems Dept and see if they have an employee who is well informed with Word. Thank you for your assistance.
Reply With Quote
  #8  
Old 10-04-2018, 05:16 PM
macropod's Avatar
macropod macropod is offline Calculating age on a Word Document Windows 7 64bit Calculating age on a Word Document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The tutorial provides all the step by step instructions you need. All you need do is follow them. As for not knowing what content controls and formfields are, I suggest you spend a little effort learning about such things. It's hard to believe you don't know what they are when your document is full of them...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Tax in Word Doc DORFER Word 4 12-21-2016 08:21 PM
Calculating age on a Word Document Word document with Macros with trusted locatin versus Word document 1997-2003 Cardinal2 Word 1 11-30-2015 07:42 PM
Calculating age on a Word Document issue in calculating field in word fillabel form expert4knowledge Word 2 12-07-2014 05:23 PM
Calculating age on a Word Document calculating duration ketanco Project 5 12-15-2011 07:15 PM
Calculating Form Fields in Microsoft Word wubba80 Word 1 06-25-2010 12:42 AM

Other Forums: Access Forums

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


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