-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
dob
-
L
Age calculation with three columns
Hi! I want to be able to calculate a person's age with the columns below. The columns may or many not be filled in. See the table below.What I need is a calculation in the forth column that will give me the current age if anyone of the three columns have data and leave the cell blank if all...- lehy2002
- Thread
- age columns current dob patient
- Replies: 1
- Forum: Excel Questions
-
B
Changing Date Of Birth To Years
Good morning all, I have the following formula created to change the Date of Birth to years. =DATEDIF(D72,NOW(),"y") The only problem that I am having is for those cells that do not contain a Date of Birth yet, the years column is showing as 114 for some reason. What formula can be used to...- bksparkz
- Thread
- change to years date of birth dob
- Replies: 3
- Forum: Excel Questions
-
H
DOB help
Hello Does anyone know how to take a column of yyyymmdd format 19970522 and change it all to exactly mm/dd/yyyy (with lines) ? I need to upload a pretty large file in this format and the raw data is in the wrong yyyymmdd format. Thanks for helping! H :eeek:- hawilder
- Thread
- dob
- Replies: 2
- Forum: Excel Questions
-
DOB from ID number
Hi there, I am looking for a formula to workout the DOB (In date format) of an Id number, been playing around with LEFT, RIGHT,TEXT, but so far no luck.- MarkCBB
- Thread
- date dob
- Replies: 8
- Forum: Excel Questions
