SOLVED

Excel Formula issue

%3CLINGO-SUB%20id%3D%22lingo-sub-205512%22%20slang%3D%22en-US%22%3EExcel%20Formula%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205512%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Excel%202016.%20I%20am%20creating%20a%20birthday%20spreadsheet.%20I%20have%20an%20Age%20column%20in%20which%20the%20formula%20is%20calculated%20upon%20the%20current%20date%20which%20is%20cell%20J1%20and%20the%20date%20of%20birth%20which%20is%20column%20D.%20My%20formula%20is%20in%20column%20E%20(Age)%20and%20is%20calculated%20as%26nbsp%3B%20%3CSPAN%3E%3DDATEDIF(D39%2C%24J%241%2C%22y%22)%26amp%3B%22%20years%22%26nbsp%3B%20which%20in%20this%20cell%20will%20show%20the%20age%20once%20D39%20birth%20date%20is%20entered.%20Every%20function%20I%20try%20shows%20False%20or%20%23Name%3F%20How%20can%20I%20get%20the%20cells%20in%20column%20E%20to%20show%20a%20blank%20until%20I%20enter%20the%20date%20of%20birth%20in%20cell%20D39%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-205512%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENone%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205682%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205682%22%20slang%3D%22en-US%22%3EThank%20you%20Peter.%20Your%20solution%20worked.%20Very%20much%20appreciated.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205543%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205543%22%20slang%3D%22en-US%22%3EYou%20need%20to%20wrap%20your%20DATEDIF%20in%20a%20IF%2C%20see%20here%20for%20a%20example%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mrexcel.com%2Fforum%2Fexcel-questions%2F541600-if-statement-datedif.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mrexcel.com%2Fforum%2Fexcel-questions%2F541600-if-statement-datedif.html%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

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?

2 Replies
best response
Solution
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

Thank you Peter. Your solution worked. Very much appreciated.