[Solved] Combine text and date in a cell

[Griff1982]

I keep track of my money using a spreadsheet. I wanted to keep track of when I update it I currently have to over 2 cells, one saying "Updated " and the next cell with the formula =Today() but I wanted this in a single cell. I've tried =Updated " &Today(), but get the date serial (Updated 45569).

I've tried the Excel formula

="Updated " &TEXT(TODAY(), "DDMMMYY") but get Err:508

Any ideas?

[MrProgrammer]

="Updated " &TEXT(TODAY(), "DDMMMYY")

="Updated " & TEXT(TODAY();"DDMMMYY")   (use a semicolon, not a comma; comma creates Err:508)

TODAY() is always the current date, so if you open the spreadsheet tomorrow the date will be different. To lock the cell so the value never changes, use F2, F9, Enter, Enter.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[Griff1982]

The semi colon seemed to have fixed it. Perfect Thank you