Importing Excel Dates to P5

K
Kylie Ferguson 👤 Member for 18 years 5 months

Thanks Mark for your advice. I have in fact fixed the problem, this is how. Export the project with a primary constraint & primary constraint date field. Enter the dates in the excel spreadsheet into the primary constraint date column and enter a Start On constraint in the constraint column. When you import, the dates come across in the constraint field, hit schedule and the start dates are then reflected as per the constraint dates.

M
Mark Chapman 👤 Member for 20 years 1 month

I don’t use this facility but I suspect the key thing here is to ensure you have the correct durations and logic then let the software calculate the dates remembering you need to configure a calendar too and this where discrepancies can occur.

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts