Automated dates to update with current fiscal year

[Rosadocc]

Hello everyone!

I'm hoping someone can help me with a formula that updates months/year to the current fiscal year.

Currently have a spreadsheet that has 12 cells with 12 dates representing the 12 months of the current fiscal year. (i.e., 10/1/2019, 11/1/2019, 12/1/2019, etc). These dates are currently just typed in but I am trying to have the 12 cells update themselves with the current fiscal year. So when the workbook is opened in the next fiscal year, the dates will automatically update to 10/1/2020, 11/1/2020, 12/1/2020, etc.

Any help will be appreciated.

 

[Fluff]

In the first cell put
=DATE(YEAR(TODAY()),10,1)
Then in the next put
=EDATE(D2,1)
And drag across, or down as needed.
Change the D2 to the cell with the first date

 

[Rosadocc]

In the first cell put
=DATE(YEAR(TODAY()),10,1)
Then in the next put
=EDATE(D2,1)
And drag across, or down as needed.
Change the D2 to the cell with the first date

@Fluff This works! Thanks so much.

 

[Fluff]

You're welcome & thanks for the feedback