CloudenL
11-30-2011, 08:39 AM
I have a project that im working on and have lots of questions, but am trying to learn, so taking it one step at a time.
So, my question for today is: In 1 cell i can input a start date (1/1/2011) and in the cell below i can input the end date (12/31/2011) if the dates inputed are not a full year or are more than a year i want a message box to come up stating dates are incorrect.
I've am not sure how to start the macro (if this is the route i should take) to calculate the date difference which then would show the error message.
I am trying to learn, so, if someone could just help me get started, i will work from there.
So, my question for today is: In 1 cell i can input a start date (1/1/2011) and in the cell below i can input the end date (12/31/2011) if the dates inputed are not a full year or are more than a year i want a message box to come up stating dates are incorrect.
I've am not sure how to start the macro (if this is the route i should take) to calculate the date difference which then would show the error message.
I am trying to learn, so, if someone could just help me get started, i will work from there.