<div>
There may be a formula but this VBA &nbsp;does something if the cell value is equal to or greater than 40 days prior to today<br />
&nbsp;
<pre><code id="code-20-42990460-1">   If  DateDiff(&quot;d&quot;, wsRenew.Cells(lngRow, &quot;B&quot;), Now) &gt;= 40 Then</code></pre>
</div>


There may be a formula but this VBA  does something if the cell value is equal to or greater than 40 days prior to today
 

   If  DateDiff("d", wsRenew.Cells(lngRow, "B"), Now) >= 40 Then

Data Specialist

Patricia Timm

<div>
Welcome, glad that helped.<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


Welcome, glad that helped.



----------------------------------------

»bp

<div>
Or TODAY function gives just the current date:<br />
<br />
=TODAY()
</div>


Or TODAY function gives just the current date:

=TODAY()

<div>
<div class="content wysiwyg-content">
Is there a way to check the current date (on the computer - maybe system date - so it grabs the current date) and then compares to a date on an excel spreadsheet like a parts ordered date in the format 11/20/2019. Not sure if I can use excel formulas or if vb code would need to be used??? thanks in advance
</div>
</div>


Is there a way to check the current date (on the computer - maybe system date - so it grabs the current date) and then compares to a date on an excel spreadsheet like a parts ordered date in the format 11/20/2019. Not sure if I can use excel formulas or if vb code would need to be used??? thanks in advance

Extracting the current date from the computer and comparing to a date in an excel spreadsheet

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

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

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.