nclrwntr

yup got that too. div by 4 but not if div by 100 but yes if div by 400

Thanks for the input all!:) I've decided to go with "year mod 4 = 0" style. Bottome line is that it works right? He should accept this. I hope........ The only reason why he wouldn't is because we haven't learned it yet in class but I figured it out on my own. That counts for something.:)

Thanks for the help bpayne.:)

Here, here. there are easier ways but we can't use them since we haven't covered it yet. blech!

lol. I forgot to mention that I'm prohibited from using that as well.:) And it doesn't seem to work.

I need to validate a date entered into a textbox in the form mm/dd/yy by using a massive compound IF statement. If the date is valid, nothing happens but if an invalid date is entered, a message box pops up saying, "invalid date." this is what I have so far: fulldate= txtdate.text month = fulldate.Substring(0, 2) day = fulldate.Substring(3, 2) year = fulldate.Substring(6, 2) If (month < 1 Or month > 12) Or (day < 1 Or day > 31) Or (year > 3 And year < 38) Or (month = 4 And day > 30) Or (month = 6 And day > 30) Or (month = 9 And day > 30) Or (month = 11 And day > 30) Then MsgBox("Invalid Date Entered", , "Data Entry Error") Exit Sub End If I've tried a lot of different things to do the leapyear and non leapyear calculations but nothing works. I can make it work using mod operators but we can't use them.