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
Bookmarks