Provide two date input boxes in excel.
The start date box lists all dates upto six months back and end date lists all dates upto six months back (day by day inlduing today)
The user can select any start date and end date from this column.
Start Free Trial