How to print current date and some text as well as some values from another cell?

Question

Hello guys I want a excel query that shows me below outout.

Timesheet : 28 August, 2018 - 03hr:05min

• First value is text (Timesheet :).

• Second value is current date with formatting as (DD MMMM, YYYY)

• and last value get from another cell.

I have tried but its not working for me:

='Timesheet : '&today()&' - '&C31

Answer 1

try,

="Timesheet : "&text(today(), "dd mmmm, yyyy")&" - "&C31
'alternate
="Timesheet : "&text(today(), "dd mmmm, yyyy - ")&text(C31, "hh\h\r:mm\m\i\n")