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!
[TABLE="width: 421"]
<tbody>[TR]
[TD]Goals[/TD]
[TD]By when?[/TD]
[TD]Priority[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Feb-20[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Jun-20[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Mar-20[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Dec-20[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]Nov-20[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Goals[/TD]
[TD]Completed by[/TD]
[TD]Goals reached?[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Jan-20[/TD]
[TD]Reached![/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Nov-20[/TD]
[TD]Reached![/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Jun-20[/TD]
[TD]Not Reached![/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]Nov-20[/TD]
[TD]Reached![/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Jul-20[/TD]
[TD]Not Reached![/TD]
[/TR]
</tbody>[/TABLE]
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!
[TABLE="width: 421"]
<tbody>[TR]
[TD]Goals[/TD]
[TD]By when?[/TD]
[TD]Priority[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Feb-20[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Jun-20[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Mar-20[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Dec-20[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]Nov-20[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Goals[/TD]
[TD]Completed by[/TD]
[TD]Goals reached?[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Jan-20[/TD]
[TD]Reached![/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Nov-20[/TD]
[TD]Reached![/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Jun-20[/TD]
[TD]Not Reached![/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]Nov-20[/TD]
[TD]Reached![/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Jul-20[/TD]
[TD]Not Reached![/TD]
[/TR]
</tbody>[/TABLE]
also posted here
https://www.excelforum.com/excel-general/1287432-dates-smaller-equal-to-or-greater-than.html
Last edited by a moderator: