<div>
you can just subtract the 2 cells and format the cell returning the difference as Number instead of date, this will return the number of days
</div>


you can just subtract the 2 cells and format the cell returning the difference as Number instead of date, this will return the number of days

<div>
<div class="content wysiwyg-content">
in MS Excel (Office 2000), what formula will produce the number of days (including weekends) between two dates. &nbsp;Example: the number of days from 2/14/99 - 2/26/99. &nbsp;The column cells for &quot;Date&quot; are formatted as a date and is column A. &nbsp;I am guessing that it is the DATEIF function, but don't know how this works. &nbsp;Thanks.
</div>
</div>


in MS Excel (Office 2000), what formula will produce the number of days (including weekends) between two dates.  Example: the number of days from 2/14/99 - 2/26/99.  The column cells for "Date" are formatted as a date and is column A.  I am guessing that it is the DATEIF function, but don't know how this works.  Thanks.

MS Excel date calculation

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.