Query required for adding formula in a field value2 = Value1 + 1 and so on....

[CJ_London]

thanks for the additional detail. You have a solution from arnel so I won't go into it any further. But just for clarity, your projects are 7 day a week operations, no breaks for weekends or bank holidays?