yes i read it and i tried, but it didnt work, it game me wrong date on 5% of the dates, and no need to be nasty, we are all here to learn or to exchange ideas.
We get a lot of people on this site who want people to do their work for them instead of learning how to do it for themselves. When someone posted a very useful link that you dismissed out of hand, and then you later posted a query that obviously would have benefited from that same link, it seemed like you fell in that camp.
When you simply say that that same link "didn't work" instead of posting the code that you used and trying to understand why it didn't work, it only reinforces the idea that you are looking for people to do your work for you instead of learning to do it for yourself.
The formulas in the link are more efficient, because they don't have to read other records.
The formulas in the link are more accurate, because they don't depend on what records are returned by the rest of the query.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA