One additional comment:
When you concatenate numbers with text, you implicitly request that the number be converted to text first. This implicit conversion is the most likely reason why the INT() method suggested by Zizi64 didn't give the desired result. INT(NOW()) should return the same number as TODAY(), but the more complex expression may lead to Calc using a different number layout.
To have complete control of conversion, use the TEXT() function.
This should work, and is more reliable than your current formula (No need to change a working product. Just sayin' so you know about it if trouble should arise.):
Code: Select all
=TEXT(TODAY()-M27;"#0")&" Days to birthday"
... or ...
=TEXT(INT(NOW())-M27;"#0")&" Days to birthday"
In many cases it is better to insert the text through formatting, or have it in an adjacent cell. This would keep the calculated day count as a number to use for further calculations. Use the
Format code field.
Format code also supports "variable formats" on 3 levels, using 3 "code segments" separated by semicolon. (there is a 4th segment allowed, which will apply to text data in the cell.) The following format code may make sense, depending on your application:
Code: Select all
#0" days to birthday";#0"days passed since birthday";"Happy birthday!"
By default the three segments apply to positive, negative and zero results respectively, but you can override those defaults.