Within a date specified function pull data from a specific cell

[Writingformulas]

Hello

Thank You for looking at my question

I have a dashboard to pull data from certain periods

Withing that data set I would like to extract the last right cell of the last period , and then the first left cell of the current

thank You

[sandy666]

duplicated post:https://www.excelforum.com/excel-for...ific-cell.html