I have a problem on date selections. Here is the scenarios.
Problem1. I have start date and end date. I Should not allow user to select start date lesser than end date and similarly end date should not be greater than start date. What is the best possible solution for this.
Problem 2: There is start date and end date, say from December 2014 to March 2015. There are few dates between these months where there is no data, say Jan 1 to Jan 4 - There is no data. If a user select this date, I need to display an error message - NO DATA FOUND.
Could you please help me in finding a solution or a function for these 2 issues.
Could you please more elaborate your problem no 1 by giving example or by attaching your workbook so that we can suggest you best possible solutions.