Autofill "Weekdays etc" not working (not in English)

aldrigoffice 

Hi

Date format and settings are controlled by the central settings of the Windows Operating System:

Start button (Windows Button) >> Settings Gear >>Time and Language >> Date , Time & Regional Formatting >> You make changes here.

on the Other hand , AutoFill Options are controlled by the "Custom Lists".

Excel comes by default with 4 built in Custom Lists (Months & Weekdays, Full & Abbreviated). If because of the Language settings, you do not have the built-in Custom lists, then, You can Create them by going to the File Tab:

File >> Excel Options >> Advanced (Shortcut ALT, F, T) >> Edit Custom Lists>> here you can either type each list  under List Entries (each value on a different line) then hit ADD or if you already have the Values in the Worksheet you can select them and hit Import

Hope that Helps

Nabil Mourad