Feb 27 2024 04:22 AM - edited Feb 27 2024 04:23 AM
Hey,
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.
Feb 27 2024 04:33 AM
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.