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) and holidays =WORKDAY(D6,3+E6,V6:X6) equaling 28-Nov
Cell AB6 – Tried =”Complete “&F6 which results in Complete 44890 (converts date to a number)
I am looking for the formula or formatting to get the cell result of Complete 28-Nov
Any guidance is appreciated. Thanks
="Complete "&TEXT(F6,"DD-MMM")You can try this formula which seems to return the intended format.
- Perfect that works, Thanks!
="Complete "&TEXT(F6,"DD-MMM")You can try this formula which seems to return the intended format.
