TODAY() Function not working?
I've had formulas calculating the number of Salvage appointments that were added to our sheet on today's date and yesterday's date for over a week now with no issue. This morning I was notified that the numbers are incorrect. I am able to filter the grid and see that we did in fact have more than 8 salvage appointments created yesterday, and we haven't had 38 added today (We actually show 0 with a creation date of today). I've attached a link below to view the sheet data and formulas. It almost like it is going by a 24 hour calendar instead of date. Anyone else have this issue or think they know why my formulas aren't working?
To identify # of salvage appointments created today:
=COUNTIFS(Created:Created, TODAY(), [Load Contents]:[Load Contents], "Salvage")
To identify the # of salvage appointments created yesterday:
=COUNTIFS(Created:Created, TODAY(-1), [Load Contents]:[Load Contents], "Salvage")
Video showing master data vs the formula numbers:
Help Article Resources
Check out the Formula Handbook template!