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.
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 ☺
