sorry, there is .. but even the name of the video says something else than your original post does (How to subtract dates from cell to cell in a table in Excel 2010)


Please save my time and try to be more explicit...

Yeah... sorry... my last post was misleading...
But thanks for your macros.
I'm looking deep at it now and try to figure out this.

I can get the number of days when I click run the macro datesubs, not auto_open.
When I click auto_open, nothing happens.

But when I run those two macros, I double click any cells and press "enter". It shows the error message:

"Cannot run the macro [my xlsm file location]. The macro may not be available in this workbook or all macros may be disabled."

here is a sample attached...
Make sure you have macro security set to "disable all macros, with notification"
and when you open this workbook, in the message bar click options-enable this macro

Attached Files

test.xlsm (17.1 KB, 12 views)

Yes, thank you very much for ya file.
The only thing that goes wrong is that when I expand the table (I set the A column a table) but for whatever reasons I didn't enter a new date. So the lastrow is empty, Excel asks me to debug the line:

can you attach a sample of your worksheet?

My Fiance.xlsm

The sample data is just meaningless, nothing personal.
The error occurs when
Ya leave the last row blank and double click any cell and press ENTER.