Forum Discussion

Ha_Bloggs's avatar
Ha_Bloggs
Copper Contributor
Jun 14, 2020

Excel Dateif function

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.

Formulas and Functions

2 Replies

  • Abiola1's avatar
    Abiola1
    MVP
    Jun 14, 2020
    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
  • hynguyen's avatar
    hynguyen
    Iron Contributor
    Jun 14, 2020

    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-40002a7b4286