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...
Alternatively, you can calculate the dates with such a SEQUENCE function, but use a custom date format to prepend (or append, or otherwise intersperse) literal text:
"Week of "m/d/yyyy;;;@(Because these cells still contain date values (intrinsically, numbers), Excel will by default right justify the displayed value. If you prefer, you can left justify the text as usual from Home | Alignment.)
This technique has the advantage that you can use the calculated dates for additional processing, such as calculations, comparisons, and lookups.
See the attached workbook.