NETDAYS failure

KyleRL
KyleRL
edited 12/09/19 in Formulas and Functions

I cannot figure out why this formula doesn't work for me. I've tried a date instead of TODAY(), same results. Any help appreciated. Both columns are formatted for dates.

Screen Shot 2018-12-11 at 1.04.56 PM.png

Screen Shot 2018-12-11 at 1.04.39 PM.png

Tags:

Comments

  • Brian W
    Brian W ✭

    Try changing the Days under Load column properties to Number/Text.

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    I second Brian's suggestion. The #Date Expected error is indicating that that column type expects a date returned, not a number. Changing that to text/number column type should resolve the issue. 

    This is a great resource for troubleshooting errors: https://help.smartsheet.com/articles/2476176-formula-error-messages

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    I used to use this all the time. I've since written many an error into formulas, so now I only need to refer back to it occasionally. Hahalaugh

    thinkspi.com

  • KyleRL
    KyleRL

    Thank you everyone, that worked. Super confusing. #DATE EXPECTED to me suggests the column should be formatted for date...

Categories