Sep 28 2020 04:05 AM
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 like that when I fill in the cell 'date back', the number of days no longer starts counting, because this is of course no longer necessary. So the formula should automatically freeze for this line when I fill in a particular cell.
Can anyone help me with this?
Greetings,
Ina
Sep 28 2020 04:10 AM
Let's say Date In is in cell D2, Date Back in E2, and Number of Days in F2.
Use the following formula in F2:
=IF(D2="","",IF(E2="",TODAY(),E2)-D2+1)
This can be filled down.
Sep 28 2020 06:39 AM
Sep 28 2020 07:15 AM
You have to replace D2 and E2 with the cells that contain Date In and Date Back, of course.
If you can't make it work, could you attach a small sample workbook without sensitive/proprietary data?
Sep 30 2020 04:18 AM
Solution@inawolters ,,
I'm sure this is what you are looking for:
=IF(NOT(ISBLANK(AB4)),"",DATEDIF(AA4,TODAY(),"D"))
You may use this one also:
=IF(NOT(ISBLANK(AB4)),"Vehicle Delivered",DATEDIF(AA4,TODAY(),"D"))
*** In cease if this post solves the issue, please mark it as Best Solution.
Oct 01 2020 10:21 PM
Sep 30 2020 04:18 AM
Solution@inawolters ,,
I'm sure this is what you are looking for:
=IF(NOT(ISBLANK(AB4)),"",DATEDIF(AA4,TODAY(),"D"))
You may use this one also:
=IF(NOT(ISBLANK(AB4)),"Vehicle Delivered",DATEDIF(AA4,TODAY(),"D"))
*** In cease if this post solves the issue, please mark it as Best Solution.