<div>
Hi,<br />
<br />
You can use excel function &quot;=Today()&quot;. This will return current date. <br />
Now you can do all the comparison and validation as you want with respect to the returned result.<br />
<br />
However, you may be already aware that this function entirely depends on the system date.<br />
<br />
Regards.<br />
<br />
A. Roy
</div>


Hi,

You can use excel function "=Today()". This will return current date.
Now you can do all the comparison and validation as you want with respect to the returned result.

However, you may be already aware that this function entirely depends on the system date.

Regards.

A. Roy

<div>
HI softpro2k,<br />
&nbsp; &nbsp; Could you suggest me how to validate that date validation using this excel function. Allowing that 10 days less than the current date. &nbsp;If you have any code or links send it to me. Thank You.
</div>


HI softpro2k,
    Could you suggest me how to validate that date validation using this excel function. Allowing that 10 days less than the current date.  If you have any code or links send it to me. Thank You.

<div>
 HI ,<br />
&nbsp; I am implementing this validations in Java script.<br />

</div>


HI ,
  I am implementing this validations in Java script.


Date-Validation.JPG

<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp; &nbsp; Any one help me to over come this problem, &nbsp;I am using Three date field drop down lists are drdYear,drdMonth,drdDay . From these drop down list i am getting date values into java script, in Java script I validating the date validations like if i select date 31 in Feb i displaying validation Properly. But My Desire is &nbsp;allow to select 10 days less than current/Present date and don't allow to select greater than the present current/Present date. Could &nbsp;any one help me. <br />
Thank you.
</div>
</div>


Hi,
    Any one help me to over come this problem,  I am using Three date field drop down lists are drdYear,drdMonth,drdDay . From these drop down list i am getting date values into java script, in Java script I validating the date validations like if i select date 31 in Feb i displaying validation Properly. But My Desire is  allow to select 10 days less than current/Present date and don't allow to select greater than the present current/Present date. Could  any one help me. 
Thank you.

Date Validation and Compare Date

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

JScript is Microsoft's dialect of the ECMAScript standard that is used in Microsoft's Internet Explorer. JScript is implemented as an Active Scripting engine, so it can be "plugged in" to OLE Automation applications that support Active Scripting, such as Internet Explorer, Active Server Pages, and Windows Script Host. It also means such applications can use multiple Active Scripting languages, e.g., JScript, VBScript or PerlScript.