Hi there
I have a spreadsheet that tracks dates/times etc and need a cell (C2) that can count the number of days since a given date (A2) but will stop counting once B2 has been input. So, we have:
A2= Date the property is made ready
B2= Date the property was let to a new tenant.
C2= Days the property is/was empty
We need to track the number of days a property is empty for, but while it is empty we need to know how long it's been empty for. So C2 needs to count days from A2 until TODAY, but once a date has been input to B2, C2 needs to automatically calculate the difference between A2 and B2.
Apologies if this is not clear.
Thanks for your help!
I have a spreadsheet that tracks dates/times etc and need a cell (C2) that can count the number of days since a given date (A2) but will stop counting once B2 has been input. So, we have:
A2= Date the property is made ready
B2= Date the property was let to a new tenant.
C2= Days the property is/was empty
We need to track the number of days a property is empty for, but while it is empty we need to know how long it's been empty for. So C2 needs to count days from A2 until TODAY, but once a date has been input to B2, C2 needs to automatically calculate the difference between A2 and B2.
Apologies if this is not clear.
Thanks for your help!