Help! What formulae I shall use to calculate serial number automatically

[Sandeep Mehta]

I want to calculate serial number automatically for the quarters. There are three dates
Project start date / Project end date /todays date (this will be the quarter date calculating automatically)
Eg. Start date - 1/11/25, End date 1/10/26....it will calculate quarters automatically (This will be the reference for todays date)
Total number of quarters = 5
Result should display as follows:
Serial no
0 30/09/24
0 31/12/24
0 31/03/25
0 30/06/25
0 30/09/25
1 31/12/25
2 31/03/26
3 30/06/26
4 30/09/26
5 30/12/26
0 31/03/27
0 30/06/27
0 30/09/27

 

[AliGW]

By definition, there cannot be FIVE quarters!

Attach a desensitised workbook, please.