Sunday, January 25, 2009

How to Calculate a Person's Age in Excel

There are many ways to calculate a person's age in Excel.

This is related to my job case. Here is the excel formula I used:

=(date-birthdate)/365.25

I've make the video guide (tips n triks / tips n tricks) how to use the formula above in YouTube (in this case we will calculate the voters ages in election day). You can watch the video below (Hope it will help).

Labels: , , , , ,

1 comment:

  1. Rakesh DasJune 19, 2014 at 9:15 AM

    Hey Nice blog.. Check out mine learnexcelwithme.blogspot.co.uk

    ReplyDelete

Comments will be moderated and reviewed, so I can follow "the progress". Sorry for inconvenient.

Subscribe to: Post Comments (Atom)

MyBlog Related Search

Custom Search