DateValue fail to get serial number

When you declare variables as

Please Login or Register  to view this content.

VBA does not act as you might expect. The variables are not both Longs. Day_ser1 has not been defined with a type so it is created with the default type of Variant.

VBA is then assuming (correctly) the variant is a date and giving the unexpected result.

You should explicitly define every variable as a particular type

Please Login or Register  to view this content.

much thanks!