HELP!
I have the following fields:
Project Task
Start Date
End Date
Days Completed
Days Remaining
Owner
Status
Notes/Results
I would like to accomplish the following:
I need a formula for Days Completed that will be based off of the start date through today's date (Does not need to go negative), and will stop counting once the status is changed to "Completed"
I need a formula for Days Remaining, that will be based off of the end date, and today's date, and will stop counting once the status is changed to "completed"
I need a formula for the row to turn red, if the status is anything other than completed AND the end date has passed today's day.
Please assist if you can!
Bookmarks