Appending new data and updating the date from above

Hello,

I am currently creating and appending information in a consolidated headcount report. I am appending the new information after the last row of information. One of my columns is a date column which has year to dates in this format (Jan 24, Feb 24 etc.) I want a node or calculation which looks at the last row of data in the date column I.e. Jun 24 update to July 24.