Excel Dates to P6

Is anybody here could inform me what format of start & finish dates in excel that could be imported straight in P6 and gives me the correct dates to P6? Is this possible? If so, this will save us time to create a project in P6 wherein we don't need to input anything in P6 but by importing all data from excel like activity ID, Activity Name, Start and Finish dates. Thus, do i need to use dates in custom format or real dates in excel or text date or gen date? All these didn't work actually. What else then?

R
Raymund de Laza 👤 Member for 16 years 7 months

Ferdinand,

Yes you are right. And make sure on the login sheet tab set the "View Durations In" matching with the duration you entered.

 

Regards,

F
Ferdinand Ancheta 👤 Member for 18 years 8 months

thanks raymund...but in this case you don't need the finish dates instead, Start & Durations.

R
Raymund de Laza 👤 Member for 16 years 7 months

Hi Ferdinand,

You need to use a real dates but have to input a constraints type CS_MANDSTART on the primary constraint type column and input also the corresponding start date in the Primary constraint date.

 

Hope this will help.

 

Regards,

Forum Sponsor

Top Posters

Neil Atkinson
5 posts
Trian Asmoro
1 posts
Soheil Barekat
4 posts
Erkan Polater
9 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts