Question concerning dates

[dualhcsniatpac]

Im thinking it is, but is it possible to check a date that has been inputted to be valid. Example: Users will enter a date that is previous to the current days. I would like it so if they try and return Feb. 30 that it spits it back. I guess i could go through and do a bunch of if statements but i would rather not.

My date inputs are 2 separate integers: coverdate1 and coverdate2 for month and day respectively.

Thanks in advance

David

 

[scottylad2]

You could put data validation on your cells, and allow onlow dates that are equal to or higher then today

Data validation-Allow-Date and make it greater than =TODAY() and anything less than todays date won't be allowed ion the cell. Not quite sure how that would pan out tomorrow though, it would stop you from putting in yesterdays date but tomorrow would it delete a date you entered today?

 

[dualhcsniatpac]

Sorry I forgot to mention im using VBA. Maybe your on the right track. Thats kinda what I was thinking about. Im not sure how to manipulate dates.

I have the code to make sure a future date has not been entered. Its just checking if it is valid or not.

ActiveCell.Offset(0, 3).NumberFormat = "@"
ActiveCell.Offset(0, 3).Value = Format(coverdate1.Value, "00") & "/" & Format(coverdate2.Value, "00")

I hope that helps