minky_boodle minky_boodle - 1 year ago 88
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 Source

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download