I use this function, TODAY(), to calculate days to an event or past said event.
I've noticed that you have to open the sheet to update or probably more accurately get the TODAY function to be active and calculate.
I use this day counts in a Dashboard and to be accurate, as mentioned, I need to open that particular worksheet.
Is there a work-around where the TODAY function or another method where the worksheet doesnot need to be opened?
Thanks!