Field value can be computed from the value of a previous record

[inksword]

After discussion with my colleague, they sometime have to create records based on sequential dates. For example:

1. record (from: 2018-1-1, to: 2018-1-31)
2. record (from: 2018-2-1, to: 2018-2-30)
3. record (from: 2018-3-1, to: 2018-3-31)
4. and so on...

Initially, I think this could not be possible. But after a second thought, I came up with some immature ideas. I can create some arithmetic expressions along side with a parameter pattern to reference dynamic record such as

1. $0 (current record)
2. $1 (the record before current record)
3. $2 (the record before $1)
4. and so on...

fields(new Map<String, Object> {
    'StartDate__c' => '{!dates.addDay($1.EndDate__c, 1)}',
    'EndDate__c' => '{!dates.addMonth($1.EndDate__c, 1)}',
    'Bigger__c' => '{!number.add($0.Smaller__c, 10)}'
})

Could this be useful? or it just complicates the generation logic. Anything simpler can be achieved?