Forum Discussion
Solved
Freeze or Stop Formula
Hello! I have created an overview of the fleet: date of car in garage, number of days in, date back ... I used the 'today' function to count how many days the car is in the garage. Now I would l...
inawolters ,,
I'm sure this is what you are looking for:
- Formula in cell AC4:
=IF(NOT(ISBLANK(AB4)),"",DATEDIF(AA4,TODAY(),"D"))- As soon you fill cell Date back with any data, may be Text, Number or Date even, you get blank in cell AC4.
You may use this one also:
=IF(NOT(ISBLANK(AB4)),"Vehicle Delivered",DATEDIF(AA4,TODAY(),"D"))- Adjust cell references in the formula as needed.
- If this not what you are looking for then please share some sample data with us.
*** In cease if this post solves the issue, please mark it as Best Solution.
Glad to help you,, since what I've suggested is working so if you feel then you may mark my post/answer as,, Best Response ☺