
Let's say the start date is in A1, and the number of dates you want to generate is in B1.
In another cell, enter the formula
=SEQUENCE(B1, , A1, 28)
Format the spill range of the formula as a date.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Using windows 11 I want to create a date sequence for every 28 days. Any ideas please
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Let's say the start date is in A1, and the number of dates you want to generate is in B1.
In another cell, enter the formula
=SEQUENCE(B1, , A1, 28)
Format the spill range of the formula as a date.