我试图做一些日期的功能在Visual Basic中。在Excel中的 NETWORKDAYS
功能正是我所需要的。是否有相同或类似的方法可以在.NET?
I'm trying to do some date math in Visual Basic. The NETWORKDAYS
function in Excel is exactly what I need. Is there an equivalent or similar method available in .NET?
看看这个:
private int CountWorkDays( DateTime startDate, DateTime endDate, List<DateTime> excludedDates )
{
int dayCount = 0;
int inc = 1;
bool endDateIsInPast = startDate > endDate;
DateTime tmpDate = startDate;
DateTime finiDate = endDate;
if( endDateIsInPast )
{
// Swap dates around
tmpDate = endDate;
finiDate = startDate;
// Set increment value to -1, so it DayCount decrements rather
// than increments
inc = -1;
}
while( tmpDate <= finiDate )
{
if( !excludedDates.Contains( tmpDate ) )
{
dayCount += inc;
}
// Move onto next day
tmpDate = tmpDate.AddDays( 1 );
}
return dayCount;
}
上一篇:Android的NDK的UnsatisfiedLinkError - 一个令人惊讶的原因惊讶、原因、Android、NDK
下一篇:如何邮寄地址添加到Android的programmaticaly联系人?联系人、地址、Android、programmaticaly