Need your Expert help of Excel formula..
How can I dynamically update the Age based on the cell value in Deadline and Status
If the status is Pending and current date is older than the Deadline value then Age should display
Current Date - Deadline
In any other scenario the Age should be empty.