Posted to microsoft.public.excel.misc

housinglad housinglad is offline

external usenet poster

Posts: 19

Validation Date

Hi

Is there anyway to validate a date to ensure that the date enetred in cell
B2 is a Monday?

Also how would it be coded to ensure that if a Monday was not entered then
it returned a error message.

Thanks

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
date validation	LM	Excel Worksheet Functions	8	November 1st 07 12:42 AM
Validation on date	jk	Excel Worksheet Functions	3	August 29th 06 01:30 AM
date validation	Bri	Excel Worksheet Functions	3	January 22nd 06 06:52 PM
date validation MAYBE	Julian Campbell	Excel Discussion (Misc queries)	1	December 28th 05 10:17 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 03:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us