Hi!
First time posting so i apologize in advance if i don't explain the issue i am having as well i should.
I have been asked to create a spreadsheet with gantt chart for the purpose of monitoring the status of a project. I've been told to keep it simple with the inclusion of a few visual aids to easily identify the tasks that are in progress, overdue and completed.
As my Excel knowledge is quite limited when it comes to formulas i was hoping someone could help me out with the following:
<tbody>
</tbody>
Looking to add to the formula in G10 so that it shows the text "Completed" if there is a date in F10.
Thanks in advance. Any assistance is greatly appreciated.
Paul
First time posting so i apologize in advance if i don't explain the issue i am having as well i should.
I have been asked to create a spreadsheet with gantt chart for the purpose of monitoring the status of a project. I've been told to keep it simple with the inclusion of a few visual aids to easily identify the tasks that are in progress, overdue and completed.
As my Excel knowledge is quite limited when it comes to formulas i was hoping someone could help me out with the following:
START (D9) | DUE (E9) | COMPLETED (F9) | STATUS (G9) |
1-1-2019 | 3-1-2019 | =IF(E10<TODAY(), "Overdue", "In Progress") |
<tbody>
</tbody>
Looking to add to the formula in G10 so that it shows the text "Completed" if there is a date in F10.
Thanks in advance. Any assistance is greatly appreciated.
Paul