If you want to assume that leapling birthdays are celebrated on 28th feb
in non leap years then

=IF(TEXT(C3,"ddmm")<TEXT(NOW(),"ddmm"),EDATE(C3,( DATEDIF(C3,NOW(),"y")+1)*12)-TODAY(),0)

EDATE is part of Analysis ToolPak add-in


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=516469