Forum Discussion
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...
="Complete "&TEXT(F6,"DD-MMM")You can try this formula which seems to return the intended format.
Perfect that works, Thanks!