Welcome!

Calculate each task's percentage completed by days gone by

Hi everyone,

I have been trying to work out how to do this using lots of threads here but don't seem to be getting anywhere.

I want to automate the percentage complete for each task, based on the dates.

So if a task has gone past its end date, it would be 100% complete.

Can anyone help?

Many thanks,

Katie

I have used this:

=IF((TODAY() - [Start Date]5) / Duration5 > 1, 1, IF((TODAY() - [Start Date]5) / Duration5 < 0, 0, (TODAY() - [Start Date]5) / Duration5))

And it looks like it works... I don't totally understand it, though.

Katie,

re: " And it looks like it works... I don't totally understand it, though."

LOL Who does, really?

You are a very trusting manager to assume, for example, that for a 5 day task, that 20% of the work is performed every day.

Craig