date validation

[Jo]

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

 

[Tom Ogilvy]

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

format the cell as Date.

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