Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2012, 12:41 PM
Microsoft Idiot Microsoft Idiot is offline Please help with age calculation!!! Windows Vista Please help with age calculation!!! Office 2007
Novice
Please help with age calculation!!!
 
Join Date: Oct 2012
Posts: 3
Microsoft Idiot is on a distinguished road
Exclamation Please help with age calculation!!!

I know this question has been asked ad nauseum. I also know that macropod has written a document all about date and time calculations in Word. Unfortunately, I cannot understand AT ALL what he is talking about.



So.......

1. I have created a form in Microsoft Word.
2. It contains a table.
3. In the table there is a field for Date of Birth.
4. Underneath, I have a field for Age.

How do I get Word to calculate the persons age in years (whole numbers) based on today's date (or the date in which the document is opened)?

I apologize for asking this again, I just need someone to explain it to me in simple English, step-by-step. Thank you in advance.

Microsoft Idiot
Reply With Quote
  #2  
Old 10-27-2012, 02:19 PM
macropod's Avatar
macropod macropod is offline Please help with age calculation!!! Windows 7 64bit Please help with age calculation!!! Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Attach a copy of you form to a post and I'll add the field to it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-27-2012, 08:37 PM
Microsoft Idiot Microsoft Idiot is offline Please help with age calculation!!! Windows Vista Please help with age calculation!!! Office 2007
Novice
Please help with age calculation!!!
 
Join Date: Oct 2012
Posts: 3
Microsoft Idiot is on a distinguished road
Default Attached File

Macropod,

Thank you so very much for your help!!!

I have attached the file, and highlighted the areas of concern in yellow.
Attached Files
File Type: docx Fugitive Information Worksheet (Revised).docx (68.1 KB, 18 views)
Reply With Quote
  #4  
Old 10-27-2012, 09:56 PM
macropod's Avatar
macropod macropod is offline Please help with age calculation!!! Windows 7 64bit Please help with age calculation!!! Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Since it appears you only need the age in years, the field calculation can be quite simple. See attached.
Attached Files
File Type: docx Fugitive Information Worksheet (Revised).docx (88.1 KB, 56 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-29-2012, 05:54 AM
Microsoft Idiot Microsoft Idiot is offline Please help with age calculation!!! Windows Vista Please help with age calculation!!! Office 2007
Novice
Please help with age calculation!!!
 
Join Date: Oct 2012
Posts: 3
Microsoft Idiot is on a distinguished road
Default

Thank you macropod, for your help!!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help with age calculation!!! the angle format (º ‘ ‘’) and calculation? Jamal NUMAN Excel 25 05-19-2012 01:50 PM
Please help with age calculation!!! Date Calculation Lights Excel 5 04-18-2012 04:31 AM
calculation of start date ketanco Project 1 02-29-2012 07:01 AM
Please help with age calculation!!! Formula calculation danbl Excel 8 02-23-2012 04:35 AM
Please help with age calculation!!! Calculation within Cells manich1 Excel 2 12-07-2011 02:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:15 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