Forum Discussion
Solved
IF condition on DATEDIF value
Dear Friends, Please help me out for the below issue. I have a DATEDIF value, and on which the IF condition is not working. But if I change the DATEDIF value to numeric mannually then the IF functio...
Riyaz,
I would solve it this way.
=LOOKUP(DATEDIF(D3,TODAY(),"M"),$H$1:$H$5,$I$1:$I$5)
Riyaz,
I would solve it this way.
=LOOKUP(DATEDIF(D3,TODAY(),"M"),$H$1:$H$5,$I$1:$I$5)
- Thank you Lewin...