Insert Last Modified Date In Excel For Mac

This Excel tutorial explains how to use the Excel FILEDATETIME function with syntax and examples.

Jan 29, 2019  For the Love of Physics - Walter Lewin - May 16, 2011 - Duration: 1:01:26. Lectures by Walter Lewin. They will make you ♥ Physics. Recommended for you.

Description

The Microsoft Excel FILEDATETIME function returns the date and time of when a file was created or last modified.

The FILEDATETIME function is a built-in function in Excel that is categorized as a File/Directory Function. It can be used as a VBA function (VBA) in Excel. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.

Syntax

The syntax for the FILEDATETIME function in Microsoft Excel is:

Parameters or Arguments

file_path
The path to a file name that you wish to retrieve the created or last modified date for.

Returns

The FILEDATETIME function returns a date value.

Applies To

  • Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Example (as VBA Function)

The FILEDATETIME function can be used in VBA code in Microsoft Excel.

Let's look at some Excel FILEDATETIME function examples and explore how to use the FILEDATETIME function in Excel VBA code:

For example:

In this example, the variable called LResult would now contain the create or last modified date for the instructions.doc file. Silicon image sil1364 dvi add2-n driver for mac.

September 30th 06, 04:55 PMposted to microsoft.public.excel.misc
external usenet poster
Posts: 22,907
How to show date printed, updated only when worksheet printed?
Sam
First off.....save a backup of your workbook.
Then use this User Defined Function
Function DocProps(prop As String)
Application.Volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function
'=DOCPROPS('last author')
'or
'=DOCPROPS('last save time')
'or
'DOCPROPS('creation date')
'or
'=DocProps('last print date')
For a list of other properties that may be available(not all are), run this
macro.
Sub props()
rw = 1
Worksheets.Add
For Each p In ActiveWorkbook.BuiltinDocumentProperties
Cells(rw, 1).Value = p.Name
rw = rw + 1
Next
End Sub
If not familiar with VBA and macros, see David McRitchie's site for more on
'getting started'.
http://www.mvps.org/dmcritchie/excel/getstarted.htm
In the meantime.....
To create a General Module, hit ALT + F11 to open the Visual Basic Editor.
Hit CRTL + R to open Project Explorer.
Find your workbook/project and select it.
Right-click and InsertModule. Paste the above code in there. Save the
workbook and hit ALT + Q to return to Excel window.
Enter the formula in any cell as shown above.
Gord Dibben Excel MVP
On Sat, 30 Sep 2006 07:44:02 -0700, Sam wrote:

I have a timesheet spreadsheet with worksheets for each day. I want the date
that a specific worksheet (e.g., Tuesday) is printed and don't want that date
to change on the worksheet until/unless that specific worksheet is printed
again. Each worksheet could/should have a different print date. Using
header/footer shows the date it is printed, but changes each day. Is there a
way to do this?
Gord Dibben MS Excel MVP

Related Post