In the below screenshot, I'm trying to get B42 to show the value of whichever cell on row 40 is under the current month's column:
As the dates are automatically generated using a transpose(arryaformula) function, each month is actually written as DD/MM/YYYY
. However, I've formatted it so only the M
and Y
show.
The formula in the bar was lifted from another answer on here but, understandably, it can't find today's date as each column name is actually the first of each month.
Could someone help me, please?