Scribd
Upload
4 views2 pages

File Date Functions in Excel

This document demonstrates worksheet functions for retrieving file date and time properties in local time and GMT. It shows the created, accessed, and modified times for the current workbook and a test file, both in local time and converted to GMT. It also displays additional time zone information like whether daylight saving time is currently in effect, the current time zone name, and the bias to GMT.

Uploaded by

Ignacio Lamana
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
4 views2 pages

File Date Functions in Excel

This document demonstrates worksheet functions for retrieving file date and time properties in local time and GMT. It shows the created, accessed, and modified times for the current workbook and a test file, both in local time and converted to GMT. It also displays additional time zone information like whether daylight saving time is currently in effect, the current time zone name, and the bias to GMT.

Uploaded by

Ignacio Lamana
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Worksheet Function For File Date And Times (in Local Time)

Demonstatrion Of Functions
File Times This Workbook C:\[Link]
Result As GMT
Time Type Local Time 0
Created #VALUE! #VALUE!
Accessed #VALUE! #VALUE!
Modified #VALUE! #VALUE!

Currently In DST: #VALUE!


Current Time Zone Name: #VALUE!
Bias To GMT #VALUE!
Current Time 3/3/2019 1:28
Current GMT #VALUE!
C:\[Link]
Result As GMT
1
#VALUE!
#VALUE!
#VALUE!

FileName Conversion
'[Link]
#VALUE!

You might also like