Forum Discussion

Kevin_Cub's avatar
Kevin_Cub
Copper Contributor
Nov 23, 2022
Solved

Formula or formatting to combine updatable date and text into a cell

Hi, I am looking for the formula or formatting to combine updatable date and text into a cell Cell D6 - Input start date 22-Nov Cell F6 - Calculate Completion Date plus weekends, extra days (E6) an...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Nov 23, 2022

    Kevin_Cub 

    ="Complete "&TEXT(F6,"DD-MMM")

    You can try this formula which seems to return the intended format.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 23, 2022

Kevin_Cub 

="Complete "&TEXT(F6,"DD-MMM")

You can try this formula which seems to return the intended format.

Resources