Leave cell blank if no data
 

Excel Experts,

I currently have a worksheet that list people's DOB and then list their age
in the next cell. I've copied all my formulas to include 10 extra lines so
additional people can be added without having to copy the formula down. The
person's DOB is listed in C and their age in D. The formula I'm using in D
is

=DATEDIF(C2,NOW(),"y")

This formula works great, except in the extra rows, it produces an outcome
of 106. I'd like for the cell to remain blank if there isn't a DOB listed in
row C.

Hope this question makes sense and thanks for any help provided.

Leave cell blank if no data
 

Try:

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

Regards

Jean-Guy

"Millerk" wrote:

Excel Experts,

I currently have a worksheet that list people's DOB and then list their age
in the next cell. I've copied all my formulas to include 10 extra lines so
additional people can be added without having to copy the formula down. The
person's DOB is listed in C and their age in D. The formula I'm using in D
is

=DATEDIF(C2,NOW(),"y")

This formula works great, except in the extra rows, it produces an outcome
of 106. I'd like for the cell to remain blank if there isn't a DOB listed in
row C.

Hope this question makes sense and thanks for any help provided.

Leave cell blank if no data
 

Thanks, works like a charm.

"pinmaster" wrote:

Try:

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

Regards

Jean-Guy

"Millerk" wrote:

Excel Experts,

I currently have a worksheet that list people's DOB and then list their age
in the next cell. I've copied all my formulas to include 10 extra lines so
additional people can be added without having to copy the formula down. The
person's DOB is listed in C and their age in D. The formula I'm using in D
is

=DATEDIF(C2,NOW(),"y")

This formula works great, except in the extra rows, it produces an outcome
of 106. I'd like for the cell to remain blank if there isn't a DOB listed in
row C.

Hope this question makes sense and thanks for any help provided.

Leave cell blank if no data
 

I can't write the formula for you, but what you need is another IF function
showing that if the cell in column C is greater than 0, to run the formula
you supplied, and to make no entry if blank--something like
=IF(C50,[formula]).

"Millerk" wrote in message
...
Excel Experts,

I currently have a worksheet that list people's DOB and then list their
age
in the next cell. I've copied all my formulas to include 10 extra lines
so
additional people can be added without having to copy the formula down.
The
person's DOB is listed in C and their age in D. The formula I'm using in
D
is

=DATEDIF(C2,NOW(),"y")

This formula works great, except in the extra rows, it produces an outcome
of 106. I'd like for the cell to remain blank if there isn't a DOB listed
in
row C.

Hope this question makes sense and thanks for any help provided.