Changing Date Of Birth To Years

[bksparkz]

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 make the formula stay in all the cells, and not show up as anything.

Thanks in advance.

.Stan

 

[VoG]

Try

=IF(D72="","",DATEDIF(D72,TODAY(),"y"))

 

[bksparkz]

Worked great thanks. One more thing I need.
I have 6 colums. The columns are as follows.
column 1 - number, column 2 - date, column 3-number, column 4 - date, column 5 - number, column 6 - date

I am looking to tally up how many rows have a number over or equal to 10 and are dated 1/1/14 to present.
For example, on row one there are 6 columns as mentioned before. If on column 3 the number is over 10, and the date is over 1/1/14 it should be counted as one. Even if the number is over 10 and over 1/1/14 on a different column in that row, it should still be counted as 1.

[TABLE="width: 356"]
<TBODY>[TR]
[TD]</SPAN>[/TD]
[TD="align: right"] </SPAN>[/TD]
[TD][/TD]
[TD="align: right"] </SPAN>[/TD]
[TD]</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[/TR]
</TBODY>[/TABLE]

[TABLE="width: 356"]
<TBODY>[TR]
[TD]</SPAN>[/TD]
[TD="align: right"] </SPAN>[/TD]
[TD][/TD]
[TD="align: right"] </SPAN>[/TD]
[TD]</SPAN>[/TD]
[TD="align: right"][/TD]
[/TR]
</TBODY>[/TABLE]

 

[West Man]

One way:
In a spare column Use =IF(AND(OR(A2>9,C2>9,E2>9),OR(B2>41639,D2>41639,F2>41639)),"Yes","No") then use countif to total the yeses