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