Im trying to keep a running total of days when something is borrowed, but when the item is returned I'd like that running total to disappear when the item is returned. and then Id like that total to be then put into a different cell. I'm sure I can make the last part happen. But I am using the following formula to calculate days out "=IF(COUNT(TODAY(),E10)<2,"",(TODAY()-E10))" which returns the current days the item has been out. But when I add the return date into cell E11 I'd like the cell the formula in to return back to blank(Or if it is possible to have it stop calculating days at that point and just leave the days out in that same column). Then I will have a different cell that calaculates the total days out. Is this possible or wishful thinking. I'm sure it is possible because this program is amazing.
Thank you for all the help.. This forum is awesome, and all of you who help are amazing people.
Bookmarks