Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
age cut off
How do I calculate the exact age, [b1] from date of birth [a1] and cut off
date that = 12-1-06? for basketball registration. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
age cut off
http://www.cpearson.com/excel/datedif.htm
There are examples to calculate a persons age. Instead of using Now() in the formula, use Date(2006, 12, 1) or a reference to a cell containing 12/1/06. "Sandyg" wrote: How do I calculate the exact age, [b1] from date of birth [a1] and cut off date that = 12-1-06? for basketball registration. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
age cut off
example; insert =TODAY() into cell A1, this will put todays date into that
cell and will update to tomorrow's date when you open it tomorrow, and so on. If your date of birth is in cell B1, then in cell C4 insert =(A1-B1)/365.25, this will give an age (you have to format cell C4 to 'General') but the age will have certain decimal places after it i.e. it will say the person is 17.5687 years old. So in cell C3 insert =LEFT(C4,2), this will give a 2 digit age. Then hide cell C4 by setting the format to custom and inserting ;;; into the 'Type:' box. "Sandyg" wrote: How do I calculate the exact age, [b1] from date of birth [a1] and cut off date that = 12-1-06? for basketball registration. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|