<div>
Hello,<br />
<br />
with the date in A1, try<br />
<br />
=A1-TODAY()<br />
<br />
Make sure to format the result as General, not date!!<br />
<br />
cheers, teylyn
</div>


Hello,

with the date in A1, try

=A1-TODAY()

Make sure to format the result as General, not date!!

cheers, teylyn

CalculateDays-VBA.xlsm

<div>
Basically in VBA, just:<br />

<pre><code id="code-20-35431517-1">Range(&quot;A1&quot;).value - Date</code></pre>
</div>


Basically in VBA, just:


Range("A1").value - Date

<div>
That works for me ...Thanks
</div>


<div>
<div class="content wysiwyg-content">
I have a cell with a date in it and I want to get a value that equates to the number of days from todays date.<br />
So if the date is 5 days ago the it should return a number of -5, similarly todays date should return 0 and tomorrows date should return 1 <br />
Thanks<br />

</div>
</div>


I have a cell with a date in it and I want to get a value that equates to the number of days from todays date.
So if the date is 5 days ago the it should return a number of -5, similarly todays date should return 0 and tomorrows date should return 1 
Thanks


Calculation in VBA of difference between TODAY and a date in another cell.

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