halesowenmum
Active Member
- Joined
- Oct 20, 2010
- Messages
- 383
- Office Version
- 365
- Platform
- Windows
Hi
Can someone help me with a formula for the following. I have to be able to show the age of some people who have been part of a pilot. The people completing the data collection sheets should have written the age in but helpfully haven't done that for some of the people. Where there is no age given there is however their date of birth. I'm wanting consistent age results in column D. DOB and Date of Contact are both date fields, age is currently a number field (you'll need to tell me if I need to change this).
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
What I need to do is for all instances like C6 is blank allow me to type in the age myself in D6 and for instances like C7 where there is a date in C7 take the date of birth and using the date of contact display the age in D7.
Is that possible to do???
Can someone help me with a formula for the following. I have to be able to show the age of some people who have been part of a pilot. The people completing the data collection sheets should have written the age in but helpfully haven't done that for some of the people. Where there is no age given there is however their date of birth. I'm wanting consistent age results in column D. DOB and Date of Contact are both date fields, age is currently a number field (you'll need to tell me if I need to change this).
B | C | D | E | F | |
5 | Name | DOB | Age | Sex | Date of contact |
6 | Harry Jones | 75 | Female | 26/04/2017 | |
7 | Laura Smith | 19/06/1942 | 04/05/2017 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
What I need to do is for all instances like C6 is blank allow me to type in the age myself in D6 and for instances like C7 where there is a date in C7 take the date of birth and using the date of contact display the age in D7.
Is that possible to do???