Excel Dateif function

%3CLINGO-SUB%20id%3D%22lingo-sub-1462112%22%20slang%3D%22en-US%22%3EExcel%20Dateif%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462112%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20using%20Microsoft%20student%20365.%20However%2C%20whenever%20I%20use%20dateif%2C%20sumif%2C%20countif....%20functions%2C%20it%20will%20show%20%23Name%20error.%20How%20can%20I%20fix%20this%20issue%3F%20Much%20appreciate%20if%20anyone%20can%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1462112%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1462156%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dateif%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462156%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F699040%22%20target%3D%22_blank%22%3E%40Ha_Bloggs%3C%2FA%3E%26nbsp%3BThere%20is%20no%20Dateif%20function%20in%20Excel.%20There%20are%20several%20common%20reasons%20for%20%23Name%20error%20if%20you%20use%20other%20listed%20functions%20-%20check%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-to-correct-a-name-error-b6d54e31-a743-4d7d-9b61-40002a7b4286%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-to-correct-a-name-error-b6d54e31-a743-4d7d-9b61-40002a7b4286%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1462272%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dateif%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462272%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou're%20getting%20the%20%23name%20error%20basically%20because%20whenever%20you%20typed%20a%20function%20I.e%20%3DSUMIF%20you%20don't%20press%20your%20Tab%20key%20to%20select%20the%20function...%3CBR%20%2F%3E%3CBR%20%2F%3ESo%2C%20whenever%20you%20type%20any%20function%2C%20always%20remember%20to%20use%20your%20Tab%20key%20on%20your%20keyboard%20to%20select%20the%20function%20with%20open%20parenthesis%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am currently using Microsoft student 365. However, whenever I use dateif, sumif, countif.... functions, it will show #Name error. How can I fix this issue? Much appreciate if anyone can help.

2 Replies
Highlighted

@Ha_Bloggs There is no Dateif function in Excel. There are several common reasons for #Name error if you use other listed functions - check at https://support.office.com/en-us/article/how-to-correct-a-name-error-b6d54e31-a743-4d7d-9b61-40002a7...

Highlighted
Hello,

You're getting the #name error basically because whenever you typed a function I.e =SUMIF you don't press your Tab key to select the function...

So, whenever you type any function, always remember to use your Tab key on your keyboard to select the function with open parenthesis