Blank DOB inserts 109 in current age - how to leave blank?

Question

Level 4

3,464 points

The kids that join the kids club I run tap their information into a numbers spreadsheet via an ipad.

When they enter their date of birth it calculates their age today.

If the date of birth cell is left blank (as it initially is) the spreadsheet displays 109.

Is there a way for it to simply leave the cell blank?

The formula I am using to calculate the current age is

=DATEDIF(K2, TODAY(), "Y")

iPad

Posted on Sep 4, 2013 8:42 AM

Reply

Answer 1

Level 7

20,383 points

Hi Jim,

This works on a MacBook Pro using Numbers'09 2.3. Not sure about Numbers on an iPad, but here goes...

Formula in B2 (and Fill Down) is:

=IF(A2="","",DATEDIF(A2,TODAY(),"Y")&"y"&DATEDIF(A2,TODAY(),"YM")&"m")

In human-speak,

IF(A2= "" [null, empty] then make me "" [null, empty] else make me jump through hoops to calculate age)

Regards,

Ian

Message was edited by: Yellowbox. Oops,had to change curly } to straight ]

Reply