hey guys as the title says I have a code that looks at the date given in mm/dd/yy format and uses the Format function to change it to "Long Date" which changes the format to "month dd, yyyy" according to my regional settings. This part works fine but the next line looks at this new format and identifies what calender week this date falls on, my calendar week starts on monday but the default is sunday so it now gives the calendar weeks as if the calendar week started on sunday. I have tried to add vbMonday as the third input in initial format part of the code and also a 2 in case that was the input style it needed but it didnt work either way.

I wonder if I'm doing something wrong or if there is a better way to do this?

Please Login or Register  to view this content.