View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Exclude blank data from formula calculation

=IF(C2="","no record of birthdate",YEAR($J$1)-YEAR(C2))


Gord Dibben MS Excel MVP

On Mon, 14 Apr 2008 02:57:00 -0700, Donna
wrote:

I have a formula =YEAR($J$1)-YEAR(C2) calculating age from date of birth.

However some of my entries do not have an entry for date of birth, so their
'age' ends up as being (for example) 108.

Is there a way of making sure the formula does not calculate these ages?

Thanks