I need to be able to figure out the number of Saturdays and the number of Sundays between two dates. I know that I can do this by looping through the series of dates between the start date and end date. Years ago I saw a piece of code that an ex-co worker wrote that accomplished this task using a formula. The formula was extemely effecient. Unfortunately I no longer have access to this code. Does anyone have an algorithm that will perform this calculation that I can make use of?
View Complete Post