I am trying to do a date minus date to get overdue reports in excel.
If I use =date, I have to enter the date each day to calculate.
If I use =today() the answer is off the wall.
How can I get excel to calculate (yyyy,mm,dd) minus today’s date = days overdue?
Any help is appreciated