date validation

  • Thread starter Thread starter Jo
  • Start date Start date
J

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
 
=CONCATENATE(B5,"/",B6,"/",B4)*1

format the cell as Date.

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