If I have a column with the date of births of a group of individuals how can
I determine their age (in the adjacent column) at their next birthday or as
of 1/1/2005?
If I have a column with the date of births of a group of individuals how can
I determine their age (in the adjacent column) at their next birthday or as
of 1/1/2005?
Hi
=DATEDIF(StartDate,EndDate,"Y") does return the number of full years between
2 dates.
=DATEDIF(StartDate,EndDate,"YM") does return the number of full months over
full years.
=DATEDIF(StartDate,EndDate,"MD") does return the number of days over full
months.
Combined formula:
=TRIM(IF(DATEDIF(StartDate,EndDate,"Y")=0,"",DATEDIF(StartDate,EndDate,"Y")
& " year" & IF(DATEDIF(StartDate,EndDate,"Y")=1,"s","")) &
IF(DATEDIF(StartDate,EndDate,"YM")=0,"", " " &
DATEDIF(StartDate,EndDate,"YM") & " month" &
IF(DATEDIF(StartDate,EndDate,"YM")=1,"s","")) &
IF(DATEDIF(StartDate,EndDate,"MD")=0,"", " " &
DATEDIF(StartDate,EndDate,"MD") & " day" &
IF(DATEDIF(StartDate,EndDate,"MD")=1,"s","")))
StartDate will be the reference to cell with birth date in it, EndDate
either a function TODAY(), or DATE(2005,1,1)
Arvi Laanemets
"Craig" <[email protected]> wrote in message
news:[email protected]...
> If I have a column with the date of births of a group of individuals how
can
> I determine their age (in the adjacent column) at their next birthday or
as
> of 1/1/2005?
>
>
You can use the =datedif() function.
You can find lots of information about =datedif() at Chip Pearson's site:
http://www.cpearson.com/excel/datedif.htm
Craig wrote:
>
> If I have a column with the date of births of a group of individuals how can
> I determine their age (in the adjacent column) at their next birthday or as
> of 1/1/2005?
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks