I have a column that contains text cells and date cells. Next to each cell of text, I need the nearest cell that is above that text and contains a date to be returned.

***Example***

[![enter image description here](https://i.stack.imgur.com/Hbr9Z.png)](https://i.stack.imgur.com/Hbr9Z.png)