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."