Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Managing Conditional Formatting Rules in Excel
  • How to Create Gantt Chart in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • How To Create Pareto Chart in Excel
  • How to count table rows in Excel

References

  • Basic INDEX MATCH approximate in Excel
  • How to get first column number in range in Excel
  • Count unique text values with criteria
  • Find closest match in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation date in specific year
  • Excel Data validation whole percentage only
  • Excel Data validation allow uppercase only
  • Excel Data validation date in next 30 days

How to show last updated date stamp in Excel

by

To add a date stamp in a workbook to indicate a “date last updated”, you can use the TEXT function.

Note: 

The TEXT function can apply number formatting to numbers just like Excel’s built-in cell formats for dates, currency, fractions, and so on. However, unlike Excel’s cell formatting, the TEXT function works inside a formula and returns a result that is text.

You can use TEXT to format numbers that appear inside other text strings. In this case, we concatenate the test “Last update” with the result provided by the TEXT function, which picks up a date from column B and formats it using the supplied number format.

You can embed the date in any format you like, using the codes that represent date formats (dd, mm ,yyyy, etc.)

 Formula

="Last update: "& TEXT(A1, "ddd, mmmm d, yyyy")

Last-updated-date-stamp How to show last updated date stamp in Excel

Explanation

In the example shown, the formula in C5 is:

="Last update: "& TEXT(B5, "ddd, mmmm d, yyyy")

With a named range

One convenient way to manage a “last updated” message in a large workbook is to use a named range to hold the date last updated, then refer to that named range in formulas elsewhere to display a last update message.

For example, you can name a cell something like “last_update”, and use that cell to enter the date last updated. Once you’ve defined the named range, you can use the formula below anywhere you like to display the same message:

="Updated: "& TEXT(last_update, "ddd, mmmm d, yyyy")

Whenever you change the date value in the named range, all formulas will update instantly, and all date stamps will stay in sync.

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use IFS function in Excel
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • IF with wildcards in Excel
  • Complete List of Excel Logical Functions, References and Examples

Date Time

  • How to calculate next day of week in Excel
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate next anniversary date or birthday in Excel
  • How to calculate months between dates in Excel
  • YEARFRAC function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Map inputs to arbitrary values in Excel
  • If cell contains one of many things in Excel
  • Group numbers at uneven intervals in Excel
  • How to randomly assign people to groups in Excel
  • Running count group by n size in Excel

General

  • How to count total number of cells in a rectangular range in Excel
  • Creating and Opening an existing file in Excel
  • Share Excel data with Word documents
  • Basic error trapping example in Excel
  • Currency vs Accounting Format in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning