minky_boodle minky_boodle - 1 month ago 10
SQL Question

Populate Cell with Next Date after Today()

I'm working in GoogleSheets and hoping to select the date most immediately following Today, and place that date in a cell which corresponds to the name in Column A of that same row.

My intuition tells me it has something to do with =HLOOKUP and =Today() functions, but beyond that I'm pretty lost.

Answer

Using you exact sample data: enter into B13 and fill down

=INDEX(B2:N2,1,MATCH(TODAY()+1,B2:N2,1)+1)
Comments