I'm trying to figure out how to calculate percentage of a jobs progress based on 3 factors.
Current calendar date
Production Start Date
Production End Date
I'm having trouble figuring it out or it's just a bad day to be thinking.
thanks
I'm trying to figure out how to calculate percentage of a jobs progress based on 3 factors.
Current calendar date
Production Start Date
Production End Date
I'm having trouble figuring it out or it's just a bad day to be thinking.
thanks
(Current Calendar Date - Production Start Date)/(Production End Date - Production Start Date)
I think I got it. Amazing how I answer my own questions.
Does this look legit?
=(min(today(),K16)-G16+1)/(K16-G16+1)
Whereas G is start date and K is end date
Yours works too, I think a simpler formula is:
=((TODAY()-G16)/(K16-G16))
My first one was modified from a google search.
Whats the diff between the two answers
Hmm, won't work as planned. As current date progresses past end date it throws off my sum of progress for the entire job.
I need a maximum of 100 percent to be entered as well.
Try this:
=(MIN(TODAY(),K16)-G16)/(K16-G16))
yes that does nicely
thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks