Return Header Based on Last Column Populated

ManicMonday84

I'm trying to figure out a formula to add a date to a particular cell, then return the 'header' value in another cell. Ideally it's a formula automated to find the last populated cell of a row, then return the 'header' of that column.

Sample situation: with the 4/1 date populated here, I want the empty green cell to read as "Mar". If the last populated cell was the 3/28, though, the empty green cell would read "Feb".

Is this possible?

Paul Newcome

Try this:

=INDEX([January 2022]$1:[March 2022]$1, 1, COUNTIFS([January 2022]@row:[March 2022]@row, @cell <> ""))

Paul Newcome

Try this:

=INDEX([January 2022]$1:[March 2022]$1, 1, COUNTIFS([January 2022]@row:[March 2022]@row, @cell <> ""))

ManicMonday84

Perfect, Paul. Thank you!!

Paul Newcome

Happy to help. 👍️