Date Format

Copper Contributor


I am in need help auto-filling dates but in the Format: The name of the day of the week, Number of the day of the week, Number of the Month of the Year. E.g. Mon 26/1. This would represent Monday 26th Jan. 

If you can tell me how or direct me to a place that shows me how it would be much appreciated. 

1 Reply


Select the first cell. Set the number format of this cell to the custom number format ddd d/m

Enter the start date using your system's short date format or as d-mmm-yyyy (for example 26-Jan-2024).

Then drag the fill handle (the little square in the lower right corner of the cell) downwards to populate the cells below with the next dates.