Thread
:
LEAP YEAR Validation
View Single Post
#
5
Posted to microsoft.public.excel.programming
William[_2_]
external usenet poster
Posts: 227
LEAP YEAR Validation
Hi CTInt04
Say you have:-
29-02-2004 in cell A1
29-02-2003 in cell A2
then the formula
=ISNUMBER(A1) in cell B1 will return TRUE
=ISNUMBER(A2) in cell B2 will return FALSE
So that is one way to check for the existence of a valid date. Note that
cells A1 and A2 should be formatted as dates.
--
XL2002
Regards
William
"CTInt04" wrote in message
...
| How do you validate a cell so it will only accept february 29th,yyyy if
the year behind has a leap year in it?
|
| For example:I do not want C2 to accept the date february 29,2003 but it
can accept Febraury 29, 2004.
|
| A B C D
|
| 1
|
| 2
|
|
| Thank you
| CTInt04
|
|
|
|
|
|
|
|
|
|
Reply With Quote
William[_2_]
View Public Profile
Find all posts by William[_2_]