Get business days

[David C]

Is there anything in System.DateTime where I can get the number of weekdays
(excluding Saturday and Sunday) between 2 dates? Thanks.

David

[John Timney \(MVP\)]

Something like this should do - initially came from code example at
aspalliance

public int GetWeekdays(DateTime startTime, DateTime endTime)
{
TimeSpan timeSp = endTime - startTime;
int iCounter = 0;
for (int i=0; i<timeSp.Days; i++)
{
DateTime dateTm = startTime.AddDays(i);
if (IsWeekDay(dateTm))
{
iCounter++;
}
}
return iCounter;
}
public bool IsWeekDay(DateTime dt)
{
if ( (dt.DayOfWeek == DayOfWeek.Saturday) || (dt.DayOfWeek ==
DayOfWeek.Sunday) )
{
return false;
}
else
{
return true;
}
}

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
"David C" <dl*****@lifetimeinc.comwrote in message
news:eU****************@TK2MSFTNGP06.phx.gbl...

Is there anything in System.DateTime where I can get the number of
weekdays (excluding Saturday and Sunday) between 2 dates? Thanks.

David

[Eliyahu Goldin]

A simple loop from the start date to the end date with checking the day and
counting Saturdays and Sundays will do this job very well. You can even
optimize it but I wouldn't bother.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"David C" <dl*****@lifetimeinc.comwrote in message
news:eU****************@TK2MSFTNGP06.phx.gbl...

Is there anything in System.DateTime where I can get the number of
weekdays (excluding Saturday and Sunday) between 2 dates? Thanks.

David

[Mark Rae [MVP]]

"Juan T. Llibre" <no***********@nowhere.comwrote in message
news:Og****************@TK2MSFTNGP04.phx.gbl...

You can also use an auxiliary calendar table...

That's what I do, plus a bit field to indicate whether the day is a public
holiday or not...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Juan T. Llibre]

Maybe this will help...if you're using SQL Server.

set datefirst 1
declare @sdate datetime
declare @edate datetime

select @sdate = '20070516' --for example, start date May, 16th
select @edate='20070531' --end date May, 31st

select datediff(day, @sdate, @edate)+1-(
select (case datepart(dw, @sdate)
when 7 then (datepart(ww, @edate)-datepart(ww, @sdate))*2-1
else (datepart(ww, @edate)-datepart(ww, @sdate))*2
end)+
(case datepart(dw, @edate)
when 6 then 1
when 7 then 2
else 0
end)
)

You can also use an auxiliary calendar table...

See :

http://sqlserver2000.databases.aspfa...dar-table.html

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================

"David C" <dl*****@lifetimeinc.comwrote in message news:eU****************@TK2MSFTNGP06.phx.gbl...

Is there anything in System.DateTime where I can get the number of weekdays (excluding Saturday and Sunday) between 2
dates? Thanks.

David