Ageing Calculations

Dear Team,

I am calculating the ageing for my action items, this formulae (=TODAY()-E4) will give the output for how many days are left over to complete my tasks (Cell E4 is my Target date)

Now the problem is once the task is completed ageing calculations should stop and show the difference between target gate and closing date can anyone please suggest some formulae

Regards,
Sagar

Maybe =IF(today()<=E4,today()-E4,F4-E4) if F4 contains closing date

Originally Posted by royUK

The TODAY Function is volatile, so it will change daily

Which is why I get older each day !