Go Back

Last updated date stamp

Read time: 25 minutes

When we add a date stamp in the worksheet as the date value and want to indicate that as the last updated date stamp in one cell. We can achieve by combining the text value “Last Updated” and date stamp as date format by using the TEXT function and Ampersand (&), the concatenating operator, in one cell.

Figure 1. Getting Last Updated Date Stamp

Formula Syntax

The syntax for the formula to get last updated date stamp is;

=Text_value&TEXT(date,"format_text")

Where,

 

  • Text_value – It is a cell reference or text string as “Last Updated: “.
  • Date – It is a cell reference of date value to return as per the custom date format.
  • Format_text – It is the custom date format in which the date value to be returned as text.
  • & – It is concatenating operator (Ampersand) to combine date and Text values in one cell.

 

 

 

Figure 2. The Formula Syntax to Get Last Updated Date Stamp

Example

Suppose we have updated date values in column B want to indicate in column C as last updated date stamp along with date value in custom date formate as “mmmm d, yyyy”. We need to use the following formula in cell C2 and drag the fill handle down to other cells in column C, such as;

="Last Updated: "&TEXT(B2,"mmmm d, yyyy")

Figure 3. The Final Preview of the Formula

Instant Connection to an Expert through our Excelchat Service:

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I need VBA coding to help apply a date stamp when a cell is updated / changed. There are multiple cells which may change and multiple date stamp columns
Solved by S. Q. in 17 mins
I have a vba code to know the last saved time stamp and the last user who saved it. Unfortunately, it does not update whenever I save the file even closing and re-opening it. It only gets updated when you double click the cell where the formula is and press enter then it gets updated. The sheet name is "Status" and the formulas are on cell M2 and Q2. Please help.
Solved by C. C. in 17 mins
need vba code to help with date stamp
Solved by X. C. in 16 mins

Leave a Comment

avatar