Hi
just enter the date value in a date format and Excel should do the rest

--
Regards
Frank Kabel
Frankfurt, Germany


CTInt04 wrote:
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