I have a problem with my excel program.
I have a userform where the user puts 2 dates. the user puts the date in format "DD/MM/YYYY".
The problem is when the excel considers the day as month and the month as the day.
e.g 02/01/2022 - 05/01/2022 = "89" and its supposed to be "3"
I can change the format and solve the problem but its keep happening when new userform is filled.
I cant change the setting of the excel, is there another way to solve the problem?