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.
=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!