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
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")))
