LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 27
Default custom data validation

I have a sheet with 6 columns of dates (K to P). K is the job start date, P
is the job end date and the ones inbetween are inbetween dates. It is
possible for some of the ones inbetween not to need to have a date in them
(left blank).
What I want to do is validate the cells so that the user cannot enter
incorrect dates. For example, enter an end date which is before the start
date. I have managed to validate just start date against end date but when
it comes to a formula to include all the columns I get lost.
PS
The entry in the cell must be greater than 01/01/2007 and today
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Custom Data Validation MuppetBaby Excel Discussion (Misc queries) 2 July 30th 07 07:06 AM
Custom Data Validation Steve E Excel Discussion (Misc queries) 1 September 2nd 06 10:16 PM
Custom Data Validation dread Excel Discussion (Misc queries) 2 July 20th 06 09:31 PM
Custom data validation Guy Normandeau Excel Discussion (Misc queries) 3 April 18th 06 04:12 PM
Data Validation - Custom Mary Ann Excel Discussion (Misc queries) 4 December 17th 05 09:22 PM


All times are GMT +1. The time now is 09:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"