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...
Checked attached sample files, that's only 14KB for the table with data only against about ~13MB with the table with about million of empty rows.
I want to underscore the comment by SergeiBaklan that you eliminate blank rows. Having those rows there may make the sheet look "prettier" but they really add nothing else from a functional point of view and make the file, as he points out, a lot larger.