Formula to estimate the date of project completion

Hi.

I need help with a formula that can estimate the overall completion date of a project based on latest date entered in the column of multiple items within the project's completion dates. The estimated completion date is assuming that each remaining item that hasn't been completed will take 7 days to complete.

Formula to estimate Item 34 date of completion assuming each remaining item will take 7 days to complete from the "latest entry date".
Item 34 date needs to automatically update according to latest entry. (i.e. If Item 12 is 01/27/23, then Item 34 would now be 06/13/23)

Hope that makes sense .

OMG Yes! That was it. Thank you!