Forum Discussion

Deleted's avatar
Deleted
Jun 19, 2018
Solved

Excel Formula issue

I am using Excel 2016. I am creating a birthday spreadsheet. I have an Age column in which the formula is calculated upon the current date which is cell J1 and the date of birth which is column D. My...
  • Peter Stilgoe's avatar
    Jun 19, 2018
    You need to wrap your DATEDIF in a IF, see here for a example:

    https://www.mrexcel.com/forum/excel-questions/541600-if-statement-datedif.html

Resources