Ok.
User enters a date into a cell that is formatted for dd/mm/yy.
User received errors when:
Ther date that is entered, is greater than one calender month from the present day. i.e if the date is today (27/11/12) and a date later than 26/12/12 is entered, it will fail valadation.
Any thoughts? I’m stumped and quick google didn’t help. (Excel 2002…yes, I know)
Thanks, Rich
EDIT: The bit I’m strugling with is the ability for excel to be able to count the approriate number of days, dependent on which months & how many days there are in each. I think simply, does excel have an inbuilt calender?!