Anybody out there, please I need a formula for an excel file am working on. I have date submitted, requested date, estimated completion date, and duration columns,
these are what i need to generate and to be calculated in weeks
In the estimatd completd date to be increased by 13.5 weeks.
Also if the date requested is greater than 7 days and work to be completed is 90% done it shoud highlighted in green, if it is 60% complete and it is less than 3 weeks it should be highlighted in yellow finally if it is 50% complete and less than 4 weeks it should be highlighted in red.
Thanks for your help
