May 29 2018
03:56 PM
- last edited on
Jul 31 2018
08:18 AM
by
TechCommunityAP
May 29 2018
03:56 PM
- last edited on
Jul 31 2018
08:18 AM
by
TechCommunityAP
I use the TODAY formula to track the amount of days a person is located in a specific room. I base the starting point as their date of registering into the room and track the amount of days they are in the room with the formula assuming C3 is the cell with the initial date (1/01/2018) =TODAY()-C3
What I need to know is when I enter a new date in a different cell that captures their departure date I want the auto-calculations to stop, but still retain the total days in the room for historical purposes.
Is there something I add to the original TODAY formula that will stop calculating once the cell with the departing date is filled in?
May 30 2018 03:05 AM