Dear all, 

I have tried to find a solution for my challenge, however I haven’t managed to find the right answer. 

In an Excel sheet, I have multiple rows with data divided over different amounts of columns. The only thing these rows have in common, is that the second to last filled cell in each row has a date (dd/mm/yyyy or dd-mm-yyyy).

I need a formula that shows this date. In orther words, I would need a formula that copies the second to last filled cell of each row into a column.

To visualize my question: looking at the table below; is there a formula (or other function) that automatically copies the dates from the yellow cells into the first (yellow) column? 

Many Thanks!

​Dear all, I have tried to find a solution for my challenge, however I haven’t managed to find the right answer.  In an Excel sheet, I have multiple rows with data divided over different amounts of columns. The only thing these rows have in common, is that the second to last filled cell in each row has a date (dd/mm/yyyy or dd-mm-yyyy). I need a formula that shows this date. In orther words, I would need a formula that copies the second to last filled cell of each row into a column. To visualize my question: looking at the table below; is there a formula (or other function) that automatically copies the dates from the yellow cells into the first (yellow) column? Many Thanks!  Read More

​