|
|
#1
05-23-2025, 01:43 AM
|
||||
|
||||
Add LastFileDate update date in cell
I would like a cell to display the computer date of the last updated date of my excell file. Looking at MS I am told to use...
=FileDateTime("D:\2_Excel_Documents\BudgetSheet.xl sx") But instead I get #NAME? Has MS got it wrong? https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-display-the-last-updated-date-of-a-source/898699fc-2b2e-49ea-89a0-1441c833c98c 
|
|
#2
05-23-2025, 03:31 AM
|
||||
|
||||
|
If you read the entire article you will see that FileDateTime is a VBA function, not a regular one
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#4
05-23-2025, 06:11 AM
|
||||
|
||||
|
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#6
05-23-2025, 08:07 AM
|
||||
|
||||
|
First method is entitled : Using the File Tab to Get the Last Modified Date and Time of the File
Is that not what you need?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#8
05-25-2025, 05:44 AM
|
||||
|
||||
|
A small " thank you for trying" with have been nice. Good luck with your quest
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#9
05-25-2025, 07:57 AM
|
||||
|
||||
|
Will the last saved date and time work for you?
If yes, then Code:
Sub LastSaved()
Dim x As Date
x = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
MsgBox (x)
End Sub
__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2511
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do i highlight a cell red if no date has been entered 30 days after a date in another cell?? | Daronovitz | Excel Programming | 10 | 07-29-2022 10:32 AM |
| Formula for looking at 1 cell with a date and then comparing it to four date ranges | LearningMom | Excel | 3 | 10-27-2017 12:44 PM |
| calculate date if date entered in cell, do nothing if blank | ConfuddledOne | Excel | 3 | 11-07-2014 09:37 AM |
| Make table cell active add date count date | MelHerndon | Word VBA | 3 | 01-21-2013 04:23 PM |
| How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
Windows 11 
Office 2021
Linear Mode
