N
Nick P
Say I have a list of birthdates (ex: 4/19/1960) and want to put the age in a
column next to it.
What is the formula?
column next to it.
What is the formula?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Take a look at Chip Pearson's site:
http://www.cpearson.com/excel/datedif.htm
And print those instructions. This function only appears in the xl2k help (but
it's available to use for all).
http://www.cpearson.com/excel/datedif.htm
And print those instructions. This function only appears in the xl2k help (but
it's available to use for all).
2
2rrs
With dob in D3;
=DATEDIF(D3,NOW(),"y")&" years, "&DATEDIF(D3,NOW(),"ym")&" months,
"&DATEDIF(D3,NOW(),"md")&" days"
4/19/1960= 43y, 4m, 7d.
=DATEDIF(D3,NOW(),"y")&" years, "&DATEDIF(D3,NOW(),"ym")&" months,
"&DATEDIF(D3,NOW(),"md")&" days"
4/19/1960= 43y, 4m, 7d.
M
MeAgain
Hi
Can you put also the Hours Minutes and secounds in this fomulas
ie 4/19/1960= 43Years, 4Months, 7Days, 5Hours, 23Minutes, 15Seconds.
Thanks
Can you put also the Hours Minutes and secounds in this fomulas
ie 4/19/1960= 43Years, 4Months, 7Days, 5Hours, 23Minutes, 15Seconds.
Thanks
R
Rafael Ortiz
In its simplest form:
=(TODAY()-A1)/365
Assumes your date is in cell A1. Make sure you format this cell to
Number with the desired decimal places AFTER you put the formula into
it. Then copy down to other cells as needed....
MRO
=(TODAY()-A1)/365
Assumes your date is in cell A1. Make sure you format this cell to
Number with the desired decimal places AFTER you put the formula into
it. Then copy down to other cells as needed....
MRO