Forum Discussion

questionasker777's avatar
questionasker777
Copper Contributor
Jan 30, 2025

Can Excel's autofill function handle dates with alternating intervals?

Hello,

I am currently trying to use Microsoft Excel to generate a list of dates for recurring meetings, as this person does in this video https://youtu.be/And7Ii-E5lM?t=227 (timestamped at 3:47). I understand that it works for him, because his dates are all 7 days apart from each other. However, my dates are on Mondays and Fridays. This means the interval would be 4 days, (mon-fri) then 3 days (fri-mon) then 4 again.

Can someone please let me know if there is a way to do this that I can't seem to figure out, or if Excel is simply unable to handle this? When I do what this gentleman does in his video it does not generate this dates out to March, April and so on- it just repeats the February ones I've provided. To be clear, I am using the exact same numbered date format as he is. I can only guess that this functionality only works when the interval is the same every time.

To whoever takes the time to read and respond- thank you, and have a wonderful year.

  • Alternatively you can enter in cell

    A1       27.01.2025

    A2       31.01.2025

    A3       = A1 + 7

    A4       = A2 + 7

    and then select A3 and A4 and fill down the formulas. In the last step you can copy the result and paste only the values.

Resources