Hi gurus,
I am trying to find out whether the below 5 goals, named A-E can be met by a specific date each. Based on priority (my company's), they will be ranked 1,2,3,4 and 5 respectively.
Then, they will run through a set of database (can't reveal here due to confidential purposes) to determine whether each goal can be completed before their original dates. If it's smaller/ equal to, it will be labelled as "Reached!", otherwise if it's greater than their original dates, it will be labelled as "Not Reached!".
Thank you for the help!
<tbody>
</tbody>
also posted here
https://www.excelforum.com/excel-general/1287432-dates-smaller-equal-to-or-greater-than.html
I am trying to find out whether the below 5 goals, named A-E can be met by a specific date each. Based on priority (my company's), they will be ranked 1,2,3,4 and 5 respectively.
Then, they will run through a set of database (can't reveal here due to confidential purposes) to determine whether each goal can be completed before their original dates. If it's smaller/ equal to, it will be labelled as "Reached!", otherwise if it's greater than their original dates, it will be labelled as "Not Reached!".
Thank you for the help!
| Goals | By when? | Priority |
| A | Feb-20 | 1 |
| B | Jun-20 | 5 |
| C | Mar-20 | 3 |
| D | Dec-20 | 2 |
| E | Nov-20 | 4 |
| Goals | Completed by | Goals reached? |
| A | Jan-20 | Reached! |
| D | Nov-20 | Reached! |
| C | Jun-20 | Not Reached! |
| E | Nov-20 | Reached! |
| B | Jul-20 | Not Reached! |
<tbody>
</tbody>
also posted here
https://www.excelforum.com/excel-general/1287432-dates-smaller-equal-to-or-greater-than.html
Last edited by a moderator:
