Cell to calculate age

D

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,362
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Is it possible in to make something in word that allows you to enter a date of birth and have it return the age? I was thinking a text box or something similar or being able to copy and paste some cells from a excel worksheet. But in that case, I need the slide bars and navigation bars to be removed.
 
Last edited:

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Sort by date Sort by votes
Hello,

If you are looking for a formula to calculate the Age :

Code: 
=YEAR(TODAY()-DATE(yearofbirth,monthofbirth,dayofbirth))-YEAR(0)

Hope this will help
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Converting partial text date to numeric value date
Replies
7
Views
482
snezana
S
J
  • Solved
Text With a Date Calculation in Cell?
Replies
2
Views
56
jdpro
J
P
  • Solved
Date Formatting Issues
2
Replies
11
Views
379
Pacman52
P
L
  • Solved
VBA Find Cell from Date listed, in Columns, Return cell to highlight in color
Replies
7
Views
458
mumps
mumps
C
  • Question Question
Return closest date based on three criteria being true, or return "no date found"
Replies
8
Views
292
chris_bosten
C

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top