Find upcoming DATE from "Tuesday"

Question

Good Morning,

I have the following right now:

Column A	Column D
21 Juli	row
Tomorrow	row
Tuesday	row
Friday	row
23 Juli	row

I want to change Tomorrow to the date tomorrow and change Friday to the next date of Friday, same for Tuesday etc.

Example: https://docs.google.com/spreadsheets/d/1nOw7fJO8c-ZgKPRTxWYjRW7ZpA9NDeC7Iw41wLGMZP8/edit#gid=0

Answer 1

try:

=ARRAYFORMULA(IFNA(VLOOKUP(A3:A, 
 TEXT(SEQUENCE(8, 1, TODAY()+8, -1), {"dddd", "dd mmmm"}), 2, 0)))

then you can do:

=ARRAYFORMULA(IFNA(VLOOKUP(A3:A, 
 TEXT(SEQUENCE(8, 1, TODAY()+8, -1), {"dddd", "dd mmmm"}), 2, 0), A3:A))

and for tomorrow:

=ARRAYFORMULA(SUBSTITUTE(IFNA(VLOOKUP(A3:A, 
 TEXT(SEQUENCE(8, 1, TODAY()+8, -1), {"dddd", "dd mmmm"}), 2, 0), A3:A), 
 "Tomorrow", TEXT(TODAY()+1, "dd mmmm")))