Hello There,
I am trying to create a simple course tracking spreadsheet within Excel.
I would like to something similar to below:
Ideally I would like the Start date and number of days passed displayed under the days column. However, when a date is entered in the finish column I would like the counting to stop and display only the days between the Start and end Dates, otherwise it would display the days passed since the start date.
I am trying to create a simple course tracking spreadsheet within Excel.
I would like to something similar to below:
Name | Start | Finish | Days | Result |
Smith | 10-7-21 | 13-7-21 | 3 | Pass |
Calvin | 10-7-21 | 2 | In Progress |
Ideally I would like the Start date and number of days passed displayed under the days column. However, when a date is entered in the finish column I would like the counting to stop and display only the days between the Start and end Dates, otherwise it would display the days passed since the start date.