Calculating Age NOT as of today but as of a date in the future
in [General]
|
From: Jim Thomlinson on 6 Apr 2010 13:58 http://www.cpearson.com/excel/datedif.aspx -- HTH... Jim Thomlinson "מיכאל (מיקי) אבידן" wrote: > One way could be: > =IF(A1<A2,DATEDIF(A1,A2,"y"),DATEDIF(A2,A1,"y")) > Micky > > > "Deb" wrote: > > > I often need to calculate student age as of a specific date. > > For example: > > A1: DOB > > A2: age as of Sept 30, 2010 > > > > I need a formula that will also work if I need to choose a date in the past > > too, such as: age as of Sept 30, 2007 > > > > Thanks in advance for your help. > > > > > > > >
From: Deb on 6 Apr 2010 14:00 Thanks! This worked perfect!! "מיכאל (מיקי) אבידן" wrote: > One way could be: > =IF(A1<A2,DATEDIF(A1,A2,"y"),DATEDIF(A2,A1,"y")) > Micky > > > "Deb" wrote: > > > I often need to calculate student age as of a specific date. > > For example: > > A1: DOB > > A2: age as of Sept 30, 2010 > > > > I need a formula that will also work if I need to choose a date in the past > > too, such as: age as of Sept 30, 2007 > > > > Thanks in advance for your help. > > > > > > > >
|
Pages: 1 Prev: Forumla Needed: Text or Number Format Next: Installation Issues |