Tag Archives: Excel

Excel VBA – On or Before Date Calculations

VBA to Calculate the Date for a Day of the Week that occurs On or Before a Given Date. Examples, Victoria Day – The Monday On or Before May 24, Memorial Day – The Monday On or Before May 31. Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | 2 Comments

Excel Prevent Access on READ ONLY Notice

I developed a time sheet system where employees sign in and out at the start and end of their shifts.  Although the file is accessible on the network it is not a designated “shared” file.  A problem occurs when the … Continue reading

Posted in Uncategorized | Tagged , , , , , | Leave a comment

Welcome to Excelytics

Spreadsheets are at the heart of many business systems, either as core tools or to serve as a supplementary data analysis tool.  My objective is to provide resources and tools that will enhance your Excel experience. I will also share … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment