Forum Discussion
Solved
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 ...
you need to convert the Date VALUE to a text format:
="Date: " & TEXT(TODAY(), "dd-mmm-yy")
you need to convert the Date VALUE to a text format:
="Date: " & TEXT(TODAY(), "dd-mmm-yy")
Thank you very much!
