Forum Discussion
TODAY Formula
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...
Lets assume the departing date is in D3 and the days calc is in E3
Then you could use this in E3
=if (D3 = "", TODAY(), D3) - C3
Or to be a little more advanced...
=if (C3 = "", 0, if ( D3 = "", Today(), D3 ) - C3
The first part C3 = "" just checks that you have entered a start date to avoid a negative number showing.
Then you could use this in E3
=if (D3 = "", TODAY(), D3) - C3
Or to be a little more advanced...
=if (C3 = "", 0, if ( D3 = "", Today(), D3 ) - C3
The first part C3 = "" just checks that you have entered a start date to avoid a negative number showing.