Forum Discussion
Using the EDATE and SEQUENCE functions but it’s skipping dates
I’m trying to create a list of dates all in one column, but it keeps skipping eight months of the twenty two month duration period and I’m not sure why.
My input was
=EDATE(B14, SEQUENCE(B15, 1, 2)
with B14 start date as Mar 2023 and B15 as 22 months since I want each month to be in a row starting from May 2023.
The output is correct from May 2023 to Feb 2024 but then it randomly skips Mar 2024 through Oct 2024 and picks up again in Nov 2024 through Feb 2025. Since i input 22 rows I’m not sure why the output is 14 rows/months. I just want it to continuously show the dates from May 2023 to Dec 2024, any suggestions?
2 Replies
Has your output range been filtered, perhaps?
The formula should work:
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
