In Excel can you calculate age from two given dates?
1 week is 7 days, so:
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
INT(DATEDIF(A1,NOW(),"md")/7) & " weeks" & MOD(DATEDIF(A1,NOW(),"md"),7) & "
days"
--
David Biddulph
Mommybritches wrote:
Can you add a "weeks" field to this?
"Bob Phillips" wrote:
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & "
months, " & DATEDIF(A1,NOW(),"md") & " days"
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Pate" wrote in message
...
We are using Excel as a manual log of visits. We would like to
screen out anyone that is not 18 years old and were looking for a
means of calculating the age from the current date and the date of
birth. Is there a function that can do this?
|