I use the formula TODAY() in the calculation but the problem is that unless the spreadsheet is opened or the filed refreshed the date stays the same. I don't know how to automate the refreshing of the date field.
I would like to leave the sheet just sit there, go to the next day, update the day and go and get the new data ... without me touching a thing.
Hope someone can help ....