Posted to microsoft.public.excel.programming

Jo[_4_]

external usenet poster

Posts: 10

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Validation Date	housinglad	Excel Discussion (Misc queries)	4	February 8th 10 09:40 PM
Date validation	jpreman	Excel Discussion (Misc queries)	7	October 30th 08 01:13 AM
Date Validation	LM	Excel Worksheet Functions	3	October 25th 07 01:59 AM
date validation	Bri	Excel Worksheet Functions	3	January 22nd 06 06:52 PM
Date Validation - Must equal Sundays date	jeridbohmann	Excel Discussion (Misc queries)	14	November 30th 05 08:40 PM

All times are GMT +1. The time now is 02:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us