Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem Dates
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering dates | Excel Worksheet Functions | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Problem with date base units for x axis | Charts and Charting in Excel |