Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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


How can quickly and easily I determine a person's age by using their birthdate?
Reply With Quote
  #2  
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: 37
SerenityNetworks
Default

Assuming cell A1 contains their birthdate then try:
Code:
=TRUNC((NOW()-A1)/365.25,0)

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.

Regards,
Andrew
Reply With Quote
Reply

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 05:33 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