Why is my WORKDAY function reporting an incorrect date?
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
-
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
Email ID: info@sspmconsultants.com
Did I answer to your question or fix the problem? Please
help
theSmartsheet 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! -
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.
-
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
Email ID: info@sspmconsultants.com
Did I answer to your question or fix the problem? Please
help
theSmartsheet 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! -
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.
-
This may help with your issue:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!