Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.

# st: RE: RE: RE: Counting Number of Week-Days

 From Nick Cox To "'statalist@hsphsun2.harvard.edu'" Subject st: RE: RE: RE: Counting Number of Week-Days Date Wed, 8 Sep 2010 10:59:59 +0100

```You could extend Martin's application by just adding a further constraint using -tin()- or -twithin()-.

Nick
n.j.cox@durham.ac.uk

Martin Weiss

***********
clear*

inp str10 date
4apr2010
15apr2010
end

gen mydate=date(date, "DMY")
set obs `=mydate[2]-mydate[1]+1'
replace mydate=mydate[1]+_n-1

form mydate %td
l
cou if !inlist(dow(mydate), 0, 6)
***********

Simone Peart Boyce

Thanks Nick.  That helps somewhat.  I actually have two dates that I would
like
to count the number of weekdays that transpire between them.  If for
example,
date1=4apr2010 and date2=15apr2010, how can I easily count the number of
weekdays between those two dates?

Nick Cox <n.j.cox@durham.ac.uk>

I'm guessing that "weekdays" means for you Monday-Friday. Given daily dates,
say
in a variable -date-, -dow(date)- is 0 ... 6 on Sunday ... Saturday.   Thus
the
examples   . count if !inlist(dow(date), 0, 6)   . count if
inrange(dow(date),
1, 5)   . egen whatever = total(inrange(dow(date)), by(somethingelse)   show

various techniques that may be useful. If this doesn't help, you may need to
be

Simone Peart Boyce

I'm trying to determine the number of week-days between two dates.
Is
there an  easy way to do this in Stata?

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```