Excel returns FALSE sometimes.... why

Solved/Closed
plato2 Posts 1 Registration date Monday 30 June 2014 Status Member Last seen 30 June 2014 - 30 Jun 2014 à 18:53
 plato - 11 Jul 2014 à 19:36
I'm using this formula to show the persons age based on date of birth. In some cases it works but in others it returns FALSE. If I change the date of birth it is a hit and miss as to whether it displays the age or FALSE. I need it to reflect the age all the time and leave the cell blank if no date of birth is displayed. Any assistance appreciated.

=IF(ISBLANK(F2),"",IF(MONTH(TODAY())>MONTH(F2),YEAR(TODAY())-YEAR(F2),IF(AND(MONTH(TODAY())=MONTH(F2),DAY(TODAY())>=DAY(F2)),YEAR(TODAY()))))
Related:

1 response

Osama_bb11 Posts 21 Registration date Sunday 25 May 2014 Status Member Last seen 25 September 2014
1 Jul 2014 à 02:40
Hi

the false because of there are missing action

=IF(ISBLANK(F2),"",IF(MONTH(TODAY())>MONTH(F2),YEAR(TODAY())-YEAR(F2),IF(AND(MONTH(TODAY())=MONTH(F2),DAY(TODAY())>=DAY(F2)),YEAR(TODAY()), "??????")))
Thank you very much