If an auto-investment falls on a day when the markets are closed, like a weekend or holiday, it’ll get placed when the markets next open, at the opening share price (just like any other market order).
For example, if an auto-investment starts on Dec 1st and is scheduled to repeat monthly, the order would be placed on Jan 1st but wouldn’t get filled until the markets reopen on Jan 2nd.