Excel Dateif function

Copper Contributor

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

@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...

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