info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Date Difference
4 views
Skip to first unread message
Art Wrok
Feb 18, 2008, 7:25:17 PM2/18/08
to
I would like a formula to determine if someone is 70 1/2 at the end of
a year. I used
=DATEDIF(DateofBirth,EndofYear,"y")
but the result is only accurate to a whole year, for example
DateofBirth = 6/30/1937 and EndofYear = 12/31/2007 gives 70.0
rather than 70.5. How can I do this?
a year. I used
=DATEDIF(DateofBirth,EndofYear,"y")
but the result is only accurate to a whole year, for example
DateofBirth = 6/30/1937 and EndofYear = 12/31/2007 gives 70.0
rather than 70.5. How can I do this?
Mangesh
Feb 20, 2008, 9:06:54 AM2/20/08
to
you could try:
=DATEDIF(DateofBirth,EndofYear,"m")/12
=DATEDIF(DateofBirth,EndofYear,"m")/12
0 new messages