Hi all,
In sheet1 cell A1, I want a formula to return the text from the dates tab for the relevant month
I.e sheet1 cell A1 I would like a formula thtat says it is currently february, so it returns the text from dates tab: cell A21, because cell A20 is february. I think it might need an index match formula? Any help much appreciated. thank you
Bookmarks