I have a list that show all our clients and a date column called 'Last Visit' and another date column called 'Next Visit'
I then have a calculated column to work out how many days it's been since we last visited the client
This is the calculation =IF(Last="","",TODAY()-Last)
For some reason it not working all the time, see the screenshot below taken 10 today, you can see the item highlighted, it shows the last visit was 13th November but the days since visit is 0
Any ideas what's wrong with the calulation?