Hi,
How do I write a formula that will give me a percentage based on elapsed time given a start date and an end date?
The second part of my question is that the percentage will change to red if the percentage completed falls behind expected percentage completed by date. Example there is 60 days between start date and end date if worked completed by day 31 is not at 50% or better the % would change color to red.
thanks
bevil
How do I write a formula that will give me a percentage based on elapsed time given a start date and an end date?
The second part of my question is that the percentage will change to red if the percentage completed falls behind expected percentage completed by date. Example there is 60 days between start date and end date if worked completed by day 31 is not at 50% or better the % would change color to red.
thanks
bevil