I have inserted teh days of a given month in my timesheet. Now I want to delete the weekend days from the list, and move the cells up. I basically have a loop that cycles down teh date entries and checks to see which days are Saturday or Sunday, then it deletes those dates.
My only problem is calculating which days are weekends. I looked up the weekdayname function and its first parameter is a number (0-7) representing the day of the week. but my data is in the form: 12/1/07, 12/2/07, 12/3/07, etc. If i knew the number for the day of the week (e.g. Mon = 1, Tue = 2, etc) for my date I wouldn't need to check for weekend status since I'd know the day already, so I'm not sure if that's the function i want.
I'm also familiar with the Day function which seems to be of no use since it returns an integer representing the day of hte month (1, 2, or 3 for my three dates above respectively).
What function can i call to test if a date is a weekend in an If statement?
GAry
Bookmarks