I am in the process of creating a sheet that shows the duration each of my machines has been on site. I am trying to us the TODAY() formula to reference the current date, but it is not working. Essentially, I am trying to use the 'Date Delivered to Site' column that I've created, and have the 'Duration on Site' column calculate how many days the machine has been on site. Can someone please help, because I am LOSING MY MIND.
Thanks in advance!
