Forum Discussion
Excel date difference formula (Today)
Hi, I am trying to calculate difference between today and expiry date I tried 2 approaches: 1st- using a following formula =I3-today() I3 is my expiry date which is written in date format 0...
In addition, I'd recommend to remove all empty rows in the table. In current sample keep only first 15.
When you start typing in next row by default table will be expanded automatically with adding formulas in columns where they are. With that you will significantly improve performance and usability.
As another comment, DATEDIF() is not required to calculate difference in days.