Why is my WORKDAY function reporting an incorrect date?

Options

I have noticed in several instances over the past few weeks where my WORKDAY formula returns an invalid date. For instance if I have a date of 8/23/22 in column 6 row 122 I would expect a formula in column 7 row 122 of =WORKDAY([6]122, 15) to return a date of 9/13/22, yet it is returning a date of 9/5/22. Any thoughts as to what is going on here?

Answers

  • Khasim
    Khasim ✭✭✭✭✭
    Options

    Hi @Brian N.

    If you don't select the column properties as date, it will return an invalid date.

    Did you include any holidays in the formula? Try the following formula. It works.



    Thanks & Regards

    Khasim

    SSPM Consultants

    Email ID: info@sspmconsultants.com

    Did I answer to your question or fix the problem? Please help the Smartsheet Community by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!

  • Brian N.
    Options

    Thank you for responding @Khasim . The strange thing about this issue is that it was fine when I setup the schedule originally, but when I went to change the number of work days in the formula that is when the formula would not compute the right number of days. I do not have any holidays specified. So at one point it was correctly indicating a date of 9/13/22. This seems to be a sporadic issue.

  • Khasim
    Khasim ✭✭✭✭✭
    Options

    Hi @Brian N. I tested it with various dates and it works perfectly. Yes, I agree that it is a sporadic problem.

    If the solution works for you, you can upvote and accept it. So that it can benefit other users like you


    Have a great day!


    Thanks & Regards

    Khasim

    SSPM Consultants

    Email ID: info@sspmconsultants.com

    Did I answer to your question or fix the problem? Please help the Smartsheet Community by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi @Brian N.

    I hope you're well and safe!

    To add to Khasim's excellent advice/answer.

    Have you checked your Project Settings?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!