Finish date imported from Excel off by one day

[craig843]

Whenever I import data from Excel into Project, the Finish date is always one day earlier than the date in the Excel spreadsheet. Does anyone know why this is and how to correct it?

 

[SkipVought]

Hi,

Are you sure that the date is off by ONE DAY and not FOUR YEARS & ONE DAY?

Excel has 2 different settings for date values -- the 1900 and 1904. I believe that the MS standard is 1900, so your Excel might be set to 1904.

Go into Excel/Tools/Options - Calculation Tab and see is the 1904 date system option is selected.

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[craig843]

Actually, it's one business day. If the date in Excel is a Monday, the finish date in Project will be the Friday before. We're really not using Project as it is intended. The employee I replaced had a schedule set up that is basically using our contract as the project and work orders as tasks and these tasks have a fixed start date and a fixed finish date. Our customer wanted a graphical schedule and the guy chose Project and now I'm stuck with it until I can redesign it in Microsoft Access. I just haven't been able to find out why the finish date is automatically changed.

 

[PDQBach]

Possibly a calendar issue -- between the start and end date of that task there is a non-working day in the calendar for the project, the calendar for the task or the calendar(s) for the resource(s) assigned to that task.

YOu might want to display the full date-and-time and see if the (for lots of reasons) the task doesn't start at the beginning of the day -- which will mean that a 1 day task (as an easy example) doesn't finish on the same day that it starts.