Excel Formulas to Find the Last Updated Date Stamp ~ Quick Tricks!!

Microsoft Excel does not provide an easy way to add a field to inform readers of when a file was last updated. This article will talk about ways to find the last updated date stamp in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

You can use the below formula to find the last updated date in Excel.

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

Syntax Explanations:

TEXT – In Excel, the TEXT function helps to convert a number to text in the given format.
A1 – It specifies the input dates from your worksheet.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Let’s consider the below example image.

First, we will enter the input dates in Column B.
Now we have to return the dates including the last update date stamp.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Closure:

Here, we have discussed the easy methods for adding the last updated date stamp to the given date in Excel. Leave a comment or reply below to let me know what you think!

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **