Link to home
Start Free TrialLog in
Avatar of SubSun
SubSunFlag for India

asked on

Dynamincally update a cell

Need your Expert help of Excel formula..

User generated imageHow 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.
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Assuming columns A to D:

=IF(C1="Pending",TODAY()-B1,"")

Format as a number or you can use custom format  

0" Days"

Thanks
Rob H
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SubSun

ASKER

Perfect!.. Thanks a lot for quick response!