Share via

WORKDAY Function Issue

Anonymous
2023-12-15T18:42:41+00:00

My WORKDAY function starts to add a day. I added "Non-Working Days" but for some reason it adds a day. How do I fix that issue?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. triptotokyo-5840 36,686 Reputation points Volunteer Moderator
    2023-12-15T19:31:01+00:00

    My WORKDAY function starts to add a day. I added "Non-Working Days" but for some reason it adds a day. How do I fix that issue?

    In F 10 I have:-

    151

    • and in F 12 I have the date:-

    Oct 1st 2008

    • and:-

    =WORKDAY(F12,151)

    • correctly displays:-

    39933

    To remove 1 day from the number shown just above:-

    =WORKDAY(F12,F10)-1

    • correctly displays:-

    39932

    Does that help?

    Was this answer helpful?

    0 comments
  2. Dillon Silzer 60,931 Reputation points Volunteer Moderator
    2023-12-15T19:01:03+00:00

    Hi Victoria,

    Can you please share a sample of the data and/or your WORKDAY function that you are using?

    Was this answer helpful?

    0 comments