I have tried the following formula but I keep receiving a "#NAME?" error message and I can't figure out how to resolve this I feel like this formula is close but something is definitely off =IF(HIRE DATE="",NO,(IF(HIRE DATE>TODAY()180,YES,NO)))The #NAME occurs in excel when it can't identify a text in a formula For example, if you misspell a function's name, excel will show the #NA Excel Questions SUM(IFS creating #NAME?Up to Excel 07, Excel allowed up to 7 levels of nested IFs In Excel 07, Excel allows up to 64 levels However, just because you can nest a lot of IFs, it doesn't mean you should Every additional level you add In this article we are going to explain how to check for errors in Excel 13
How To Correct A Name Error
