Separate weekends in date

[Nunina]

Hi Guys!

I have the following situation. After calculating the difference between two dates, I need to separate the weekends contained within those two dates.

Do you guys have any idea how to do that?

Thanks!



Issys Pouerie
Systems Support Analyst
San Juan, Puerto Rico

 

[Nunina]

Maybe I should be a little more specific.

For example, I calculate the days between 06/01/2004 and 06/15/2004. This is a total of 14 days. Within those 14 days there are 2 weekends (2 Saturdays and 2 Sundays.) I need a way to show those 2 saturdays and those 2 sundays.

Thanks a lot, guys!!!!

Nunina

Issys Pouerie
Systems Support Analyst
San Juan, Puerto Rico

 

[SgtJarrow]

Not the most graceful....and I think I've seen at least one more FAQ on this.....but my FAQ

faq705-4531

has a function for this.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com