ExcelBanter - Problem Dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Problem Dates (https://www.excelbanter.com/excel-discussion-misc-queries/45534-problem-dates.html)

I am trying to validate an excel spreadsheet which carries out functions on
dates. I have to come up with a comprehensive list of "problem dates" (such
as 29th Feb on a non-leap year) to check that the corect error message is
given.

Does such a list exist or does anyone know of these dates?

Andy

Hi Andy

Where is the date going to be entered? If it is going to be entered into
a cell on a spreadsheet then excel will know if the date is valid or
not. If, for example, the date is being entered in Cell A1 you could
have a formula in B1 something like this:
=IF(ISTEXT(A1),"That is not a valid date","")

If you enter 29/02/2005 in A1 the error message will show. If you enter
28/02/2005 B1 will be blank.

I hope this can get you started
Regards
Rowan

Andy Cohen wrote:
I am trying to validate an excel spreadsheet which carries out functions on
dates. I have to come up with a comprehensive list of "problem dates" (such
as 29th Feb on a non-leap year) to check that the corect error message is
given.

Does such a list exist or does anyone know of these dates?

Andy