Why is my sheet adding an extra day to any Finish date I enter?

In my sheet, for tasks that have predecessors, changing the Finish date automatically adds an extra day (or more, if there's a weekend/holiday there too.)

E.g., if I select 8/20/24, it very briefly displays that, and then flips over to 8/21/24.

This is only happening on rows with predecessors. Thoughts?

Thanks in advance.

Find more posts tagged with

Accepted answers

All comments

Will.Parente

What's in your duration column? Try putting a 0 and see if that fixes it.

malden

Hi @Will.Parente , thanks for the suggestion. I just tried that, but it didn't change anything. When I put 0 in the duration column and then extended the finish date, it did the same thing again. Added an extra day.

Will.Parente

Ok, weird. I was able to recreate the issue but it required an unnatural act. So, I have questions.

Are you pushing back the finish date and expecting the Start Date to also change? I was able to create the same error when I pushed the finish date earlier than the start date.
Are you using a formula or cell link or anything that would impact any of the columns being discussed?
Do you have any other types of predecessors on the sheet? (SS, SF, etc) - This shouldn't matter but curious
Do you have multiple predecessors on those rows?

Also, confirm that your working days are set appropriately under project settings - that should remove the weekend/holiday issue.

malden

No, not expecting the Start date to change. I'm only changing the Finish date to be in the future compared to the Start date.
No formulas or cell links should be affecting the Start, Finish, or Duration columns.
No SF or SS dependencies in the sheet
No multiple predecessors, just one predecessor per row.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.