I'm looking to offset from =today(), for example:
If cell A13=today(), display cell A20.
If cell B13=today(), display cell B20.
If cell C13=today(), display cell C20.
I want to do this for 365 rows. Is there a simpler way of doing this than a huge nested IF statement?
Solved by K. H. in 12 mins