How do you calculate overdue dates?
Hi,
I am creating a sheet to maintain our fleet. I have a column with the registration and a column with the Tax and MOT due dates. I need a formula to calculate the number of dates that are overdue for the summary but everything I try isn't working.
Does anyone know a formula for this?
Thank you in advance.
Answers
-
Hi @Sales Team
I hope you're well and safe!
Try something like this. (Replace the column name with yours)
=COUNTIF(Date:Date, <TODAY())
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!