Hi All,
I'm new to the forum and don't know if anyone could help.
I need a formula to be able compare the movement of two finish dates. For example;
If task = 100% Complete then 0
If finish date is greater than finish1 date then 1
If finish date is less than finish1 date then 2
If finish date is equal to finish date then 3
If either finish date or finish1 date is 'NA' then leave blank.
I could then add indicators to show the movement.
I hope this makes sense and would be really grateful if anyone knows the formula that could produce this outcome or point me to someone who can.
Many thanks
Gogglebox
I'm new to the forum and don't know if anyone could help.
I need a formula to be able compare the movement of two finish dates. For example;
If task = 100% Complete then 0
If finish date is greater than finish1 date then 1
If finish date is less than finish1 date then 2
If finish date is equal to finish date then 3
If either finish date or finish1 date is 'NA' then leave blank.
I could then add indicators to show the movement.
I hope this makes sense and would be really grateful if anyone knows the formula that could produce this outcome or point me to someone who can.
Many thanks
Gogglebox