Forum Discussion
Excel Formula
Greetings!
In cell A1, I have used the formula =TODAY for date.
But when I used the following formula, ="Date:"&" "&TODAY it becomes like A3 cell.
I need the result as like as in cell A5.
Please help me. Thanks in advance.
you need to convert the Date VALUE to a text format:
="Date: " & TEXT(TODAY(), "dd-mmm-yy")
2 Replies
m_tarler is giving you correct information. Here's the background information:
Excel stores dates as the number of days since 31 Dec 1899 (approximately, and depending on your date system setting — 1900 vs 1904). Those numbers sometimes appear, e.g., when you press Ctrl+apostrophe in the cell beneath a date literal (not a formula that results in a date), but before you press Enter or Tab to commit. That representation allows for easy date comparisons (less than, greater than) and simple date arithmetic (e.g., subtracting an earlier date from a later date gives the number of days between the two; or 4 days in the future can be obtained by adding 4 to TODAY()).
(And time-of-day is a decimal value between 0 and almost 1.)
The TEXT function converts a number to text using the specified format string. More info on format strings is available at this oldie-but-goodie web page.
In the future, please identify which Excel product you are using (e.g., Excel 365, Excel 2019) on which platform (Windows, Mac, web...), as the proper solution(s) may depend on that information.
you need to convert the Date VALUE to a text format:
="Date: " & TEXT(TODAY(), "dd-mmm-yy")
