Here you will see my columns, and my archive (2nd sheet) is the same, i have an automation that basically says when the next recurring date has populated and it is -2 days old to move that over to my main sheet, and that is working for me.
My question is, is there an automation or a formula where when it is moved back to my main sheet that the date on Next Recurring Date, will now show up on date column, or will that be a manual update.