Hi,
Would there be a possibility to get the Excel sheet with the correct date in the cells or is that something which you would want to include in the process?
If you want to include it, read the range and create DT1. Filter on the non empty cells and create a DT2 and assign the first value to a string variable.
Use For Each Row within DT1, use an If activity to check if the next cell is empty. If yes write the value from DT2.
If not empty get the next value from DT2 and assign that one to the string variable. That way it will use that value to fill in the empty cells with the correct date.
Here you can get an idea with the If activity.
Then you can filter it or write it according to what you need in the other Excel sheet.