date validation

Hi there, I have Data Validation set on my date entry cells so only a valid date can be entered. The formula I am using is =AND(ISNUMBER(E158),LEFT(CELL("format",E158),1)="D") and this works fine. However, when no date has yet been entered, I would like the cell to read "Enter Date". I tried...

Hi experts! I have been trying to make a data validation work. It's simple. I need to be sure, firstly that the data in column I is a valid date. Secondly, if the column D is not "NIT" it should be greater than 1/1/1900. For any other value in column D I need to be sure that the date is more...

Hi folks, Any here is appreciated. What I am trying to do. I am creating a legal document that must express an interest rate that changes annually. I need to reference a date, see where that date falls between two dates and suck out the interest corresponding to it from an array table. If...

Hello Smartest Excellers in the World, I am trying to use data validation to restrict date values entered into a cell. I am not able to use macros to accomplish this because the form that I am creating will be distributed to many users (who are not likely to have macros enabled). Essentially...

Hi Friends, I am struggling with a small code. I have a text box in which date will be entered. I am using the following code to validate and format the date. Private Sub txtTDate_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) If IsDate(txtTDate.Value) Or txtTDate.Value > Date Then...

Im using Excel2007 and i have a sheet and a button that checks or compare the date i enter with the date today example Name sex validation today doms male 03/30/11 04/26/11 nicas fema 04/26/11 04/26/11 congi male 04/29/11 04/26/11 then if the date today and the date of validation will be...