CREATETHEFUTURE.COM

Our Mission: To provide tools to
create the future you envision!

What's New?

 

About Us | Contact Us | Site Map

Home
Microsoft Office Tips
Excel Tips
FrontPage Tips
PowerPoint Tips
Word Tips
Access Tips

 

Weekly Picks

Cool Websites
Key Trends
Useful Resources
Publications
Tech Tips

Tech Tip of the Week: August  24 - 30, 2008

Calculate a Person's Age in Excel

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. This function makes it easy to calculate a person's age. To try this:

  1. In a blank worksheet, type a birth date in cell A1, using slashes to separate day, month, and year.
  2. In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

The age (in years) will be displayed in cell A2.


View all Access Tech Tips

View an alphabetical listing of Access Tech Tips

View all Excel Tech Tips

View an alphabetical listing of Excel Tech Tips

View all FrontPage Tech Tips

View an alphabetical listing of FrontPage Tech Tips

View all Office Tech Tips

View an alphabetical listing of Office Tech Tips

View all PowerPoint Tech Tips

View an alphabetical listing of PowerPoint Tech Tips

View all Word Tech Tips

View an alphabetical listing of Word Tech Tips


"You must be the change you want to see in the world." Mahatma Gandhi  View Past Quotes

frank@createthefuture.com susan@createthefuture.com

© 2008 Creative Information Systems 

 In Association with Amazon.com

Revised: August 25, 2008