SubSun
asked on
Dynamincally update a cell
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect!.. Thanks a lot for quick response!
asked on
ASKER
=IF(C1="Pending",TODAY()-B
Format as a number or you can use custom format
0" Days"
Thanks
Rob H