Forum Discussion
questionasker777
Jan 30, 2025Copper Contributor
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.
- OliverScheurichGold Contributor
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.