Excel Forum
Similar Content
Highlight Rows that Meet a Certain Condition in Excel
Tutorial: In this tutorial I am going to cover how to highlight rows that meet a certain condition. ...
Add Background Photos / Images to Comments in Excel
Macro: Add background images and photos to your comments in Excel with this macro. This macr...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick 547: Calculating Last Time File Was Accessed From Server Computer


See how to analyze data dump from server computer to see when each file was last accessed using COUNTIF, MAX and IF functions and an array formula.





Got a Question? Ask it Here in the Forum.