29168112.xlsm

RWayneH

<div>
Yup, had to use: Selection.NumberFormat = &quot;m/d/yyyy&quot;
</div>


Yup, had to use: Selection.NumberFormat = "m/d/yyyy"

<div>
Is there anything else I can do for you here?
</div>


Is there anything else I can do for you here?

<div>
<div class="content wysiwyg-content">
Must be doing something wrg. &nbsp;Every date I give it is less than today. &nbsp;Using yyyy-mm-dd format, tried formatting data as ShortDate, General, and others... still can not get this to recognize a date as in the future? &nbsp;It does not give me a positive number for 9999-12-31? &nbsp;Any ideas? &nbsp;Please advise and thanks. <br />
<br />

<pre><code id="code-10-29168112-1"> TargetDate  = ActiveCell.Value 'format?
            Diff = DateDiff(&quot;d&quot;, Now, TargetDate)
            If Diff &lt; 0 Then
                MsgBox (&quot;Date is in the past, less than today&quot; &amp; Diff)
            ElseIf Diff &gt; 0 Then
                MsgBox (&quot;Date is in the future, greater than today&quot; &amp; Diff)
            End If</code></pre>
</div>
</div>


Must be doing something wrg.  Every date I give it is less than today.  Using yyyy-mm-dd format, tried formatting data as ShortDate, General, and others... still can not get this to recognize a date as in the future?  It does not give me a positive number for 9999-12-31?  Any ideas?  Please advise and thanks. 

(CODE)

Is ActiveCell &gt; or &lt; today?

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

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.

Is ActiveCell &gt; or &lt; today?

Is ActiveCell > or < today?