date validation
 

Hi
I need to validate a date, the day, month and year are
entered into separate cells. I conmbine them using the
following formula.
=CONCATENATE(B5,"/",B6,"/",B4)
This is not recognised as a date. I need to check the
user has not enter 30 Feb.
What is the best way to do this either through worksheet
functions or through VB?
Thanks
Jo

date validation
 

=CONCATENATE(B5,"/",B6,"/",B4)*1

format the cell as Date.

It will show #Value if an invalid date is entered.

--
Regards,
Tom Ogilvy




"Jo" wrote in message
...
Hi
I need to validate a date, the day, month and year are
entered into separate cells. I conmbine them using the
following formula.
=CONCATENATE(B5,"/",B6,"/",B4)
This is not recognised as a date. I need to check the
user has not enter 30 Feb.
What is the best way to do this either through worksheet
functions or through VB?
Thanks
Jo