Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Date & Time functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - PersonAge function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Date and Time - PersonAge

Syntax:
=PersonAge(BirthDate, Optional AtDate)

Description:
Returns the age of a person given the birth date. If the AtDate date value is given the person age at that date will be calculated, otherwise the age will be calculated at the computer's system date.

Example:
=PersonAge("25-Jun-1970")

litLIB