I need to create a table that will calculate ages, based on a specific date (01/01/2018), and that will leave the cell blank if a birthdate isn't entered.

I've used =DATEDIF(B1,C1,"y") but if I do not enter a birthdate, the Age cell will show 118 throughout the rest of the table. My table looks like:

*Student   *Birthdate   *Age Deadline(01/01/2018)  *Age

Any help is much appreciated!


How about IF(DATEDIF(B1,C1,"y")=118,"",DATEDIF(B1,C1,"y"))

Sorry doing this on a phone so not tested...but should work fine

  • It may be simpler to just return a blank if DOB is blank, i.e. =IF(B1="","",DATEDIF(B1,C1,"y")) - also allows the possibility of 118 year old students!!! Oct 27 '17 at 23:02
  • @barryhoudini will you post your version as an answer?
    – Solar Mike
    Oct 28 '17 at 6:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.