spinmaniac2
New Member
- Joined
- Oct 12, 2017
- Messages
- 2
Hi all, I am having issues with a nested formula (unless someone had a better idea...lol) here is what I have
A1 - Date (this is manually entered)
B1 - Age (in days) using the following formula - =IF(ISBLANK(A2),"",TODAY()-A2)
C1 - Status - this is manually entered - "Completed", "in progress" etc.
What I am trying to figure out is how to get the formula in B1 to stop counting, and retain the last value, if C1 states "completed"
Any ideas?
Thanks so much.
A1 - Date (this is manually entered)
B1 - Age (in days) using the following formula - =IF(ISBLANK(A2),"",TODAY()-A2)
C1 - Status - this is manually entered - "Completed", "in progress" etc.
What I am trying to figure out is how to get the formula in B1 to stop counting, and retain the last value, if C1 states "completed"
Any ideas?
Thanks so much.