Jul 13, 2023 11:52 AM
Hello,
I am trying to use the WORKDAY function to add X amount of days to my start date, however it is populating an extra day but only if I include the time. I don't need to include the time but its the only way I can get the project "duration" to show up on the calendar or timeline view. Can anyone help please? I've tried to add -1 days to remove a day from the start day but it is telling me there is an error.
Current Formula: WORKDAY({Start Date}, {# of Days})
Thank you,
Jul 13, 2023 04:30 PM
Hello @STCKNB1993 ,
If "-1" is a number, it should be fine.
Is the value of "{# of Days}" a string?
If formulas are available. Try using the VALUE function.
Jul 14, 2023 07:00 AM
# of Days is just a number