Dynamincally update a cell

Need your Expert help of Excel formula..

SampleHow 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.
LVL 40
SubsunAsked:
Who is Participating?
 
Rob HensonFinance AnalystCommented:
Amendment - didn't see the fact that Deadline could still be in future.

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

Thanks
Rob H
0
 
Rob HensonFinance AnalystCommented:
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
0
 
SubsunAuthor Commented:
Perfect!.. Thanks a lot for quick response!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.