Page 1 of 1
[Solved] Combine text and date in a cell
Posted: Thu Oct 31, 2024 8:24 pm
by 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?
Re: Adding the date to a cell
Posted: Thu Oct 31, 2024 10:10 pm
by MrProgrammer
Griff1982 wrote: ↑Thu Oct 31, 2024 8:24 pm
="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
Re: Adding the date to a cell
Posted: Thu Oct 31, 2024 10:15 pm
by Griff1982
The semi colon seemed to have fixed it. Perfect Thank you