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