Forum Discussion
help with formula and date and text oh my
Hello, I am trying to figure out how to create a formula in a cell that will include Text and a date that will change by 7 days. An example is I want the Cell to read: Week of 12/5/2023 and the nex...
You can use SEQUENCE to generate the dates. If there's something in your sheet that tells how many dates to add, this formula could be refined even more:
This example generates 10 dates
=LET(
date_text, "Week of ",
start, DATE(2023, 12, 5),
dates, 10,
date_text & TEXT(SEQUENCE(dates, , start, 7), "m/d/yyy")
)