I am in desperate need to help with a project tracking/management tool. Specifically I need to calculate delays in milestones. I have been researching for a while now and can not decide on the best method. As of now I would like to show the current task due for the project (drawings , tooling, samlples) and how far they are behind each day. This should fairly simple - but I would like it to be automated.
If the actual date of completion is blank on the date I would like it to pull what milestone is currently blank and how many days past the original schedule we are. From what I am reading this is pretty straight forward if you are experienced in excel - which I am not.
The milestone, actual date, and original date are all on the same row.