Forum Discussion
Deleted
Jun 19, 2018Excel 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 formula is in column E (Age) and is calculated as =DATEDIF(D39,$J$1,"y")&" years" which in this cell will show the age once D39 birth date is entered. Every function I try shows False or #Name? How can I get the cells in column E to show a blank until I enter the date of birth in cell D39?
- 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
2 Replies
Sort By
- Peter StilgoeIron ContributorYou 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- DeletedThank you Peter. Your solution worked. Very much appreciated.