<div>
A link to Excel DAYS360 function from Microsoft.<br />
<br />
&nbsp; &nbsp; &nbsp;<a href="http://office.microsoft.com/en-us/excel/HP052090471033.aspx" rel="ugc">http://office.microsoft.com/en-us/excel/HP052090471033.aspx</a> <br />
<br />
Fernando
</div>


A link to Excel DAYS360 function from Microsoft.

     http://office.microsoft.com/en-us/excel/HP052090471033.aspx [http://office.microsoft.com/en-us/excel/HP052090471033.aspx]

Fernando

<div>
<div class="content wysiwyg-content">
I am using the following routine:<br />
<br />
Microsoft.VisualBasic.Date<wbr />AndTime.Da<wbr />teDiff(Int<wbr />erval, startDate, endDate, Microsoft.VisualBasic.Firs<wbr />tDayOfWeek<wbr />.System, Microsoft.VisualBasic.Firs<wbr />tWeekOfYea<wbr />r.System);<wbr /><br />
<br />
This gives me the difference in dates. I use the following dates:<br />
<br />
When I use the function with startDate = 11/09/2006 and endDate = 2/09/2007 the result is 92 days.<br />
When I use the function with startDate = 11/16/2006 and endDate = 2/09/2007 the result is 84 days.<br />
<br />
However, in MS-Excel, when I take the difference between the sets of dates for the first one the difference is 92 days.<br />
for the second one the difference is 84 days. &nbsp;I tried simply subtracting the dates in C# as well and the result is still diffferent for the second set.<br />
<br />
Thanks
</div>
</div>


I am using the following routine:

Microsoft.VisualBasic.DateAndTime.DateDiff(Interval, startDate, endDate, Microsoft.VisualBasic.FirstDayOfWeek.System, Microsoft.VisualBasic.FirstWeekOfYear.System);

This gives me the difference in dates. I use the following dates:

When I use the function with startDate = 11/09/2006 and endDate = 2/09/2007 the result is 92 days.
When I use the function with startDate = 11/16/2006 and endDate = 2/09/2007 the result is 84 days.

However, in MS-Excel, when I take the difference between the sets of dates for the first one the difference is 92 days.
for the second one the difference is 84 days.  I tried simply subtracting the dates in C# as well and the result is still diffferent for the second set.

Thanks

DateDiff different than MS Excel

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).