Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
XL: How to Display the Current Date and Time with Text
Article ID: 214093 - View products that this article applies to.
This article was previously published under Q214093
You can enter the current date and time as text by using the TEXT function with the TODAY or NOW functions. For example, to display
Today is 2/18/98where 2/18/98 is the current date, use the following formula:
="Today is "TEXT(TODAY(),"m/d/yy")NOTE: You can substitute the NOW function for the TODAY function in the preceding formula to display the date and time or just the time (depending on the number format that you specify).
You can also display
Today is 2/18/98and preserve the value of the date as a serial number rather than converting it to text.
To display the current time, use the following formula:
=NOW()-TODAY()This formula updates each time the sheet is calculated.
The TEXT() function converts a value to text in a specified number format.
To display the following text
The current date and time is 2/18/93 5:57 PMuse this formula:
="The current date and time is "&TEXT(NOW(),"m/d/yy h:mm AM/PM")To display the following text
The current time is 5:57 PMuse this formula:
="The current time is "&TEXT(NOW(),"h:mm AM/PM")If you want a linked formula in a chart to display this information but you do not want to open the file, use the TEXT() function.
To display the time but preserve the value as a serial number, follow these steps:
Today is m/d/yywhere m/d/yy is the current date and is displayed in the format that you selected in step 3. The value of the date is stored as a serial number.
Article ID: 214093 - Last Review: January 24, 2007 - Revision: 2.2