Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 08-03-2006, 02:46 PM
gdodson gdodson is offline
Determine age by using birthdate
Join Date: Aug 2006
Location: CC, TX
Posts: 1
Default Determine age by using birthdate

How can quickly and easily I determine a person's age by using their birthdate?
Reply With Quote
Old 08-11-2006, 09:27 PM
SerenityNetworks SerenityNetworks is offline Determine age by using birthdate Windows 10 Determine age by using birthdate Office 2016
Advanced Beginner
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 33

Assuming cell A1 contains their birthdate then try:

now() will return the serial number for the present time.
you subtract their birthday from "now"
that will give you a number
divide that number by 365.25 (since every 4th year is a leapyear)
use TRUNC to just return the year (since people don't round up their age - after 21 )
that should do it.

Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to determine a user's mailbox size limit? enviroko Outlook 3 05-13-2010 07:02 AM
Anyway to determine time/date of text creation? pureride Word 1 01-05-2010 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 PM.

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