Monthly Archives: July 2010

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

Advertisements
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