halesowenmum
Active Member
- Joined
- Oct 20, 2010
- Messages
- 383
- Office Version
- 365
- Platform
- Windows
Hi.
I have a spreadsheet with the following layout:
<tbody>
</tbody><strike></strike>
1. What formula do I need in J5 and J6
2. What CF do I need in J5 and J6
Progress bar would show how much time the person had used - they could then compare this to the % progress they enter elsewhere on the sheet to see if they look on track based on the time remaining to complete the item.
Thank you.
I have a spreadsheet with the following layout:
H | I | J | |
Due date | Today | ||
5 | 15/11/2019 | =TODAY()<strike></strike> | Progress bar needed |
6 | 24/12/2019 | =TODAY()<strike></strike> | Progress bar needed <strike></strike> |
<tbody>
</tbody>
1. What formula do I need in J5 and J6
2. What CF do I need in J5 and J6
Progress bar would show how much time the person had used - they could then compare this to the % progress they enter elsewhere on the sheet to see if they look on track based on the time remaining to complete the item.
Thank you.
Last edited: