The last working day of June is

=WORKDAY(WORKDAY(DATE(2006,7,0),1),-1)

The first in July is

=WORKDAY(DATE(2006,7,0),1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"GARY" wrote in message
oups.com...
Assuming a "normal" work-week of Monday thru Friday, I'm trying to
define a range of "valid" dates starting on the last 'working-day" in
June and the ending on the first "working-day" in July {not including
Saturday, Sundays or U.S. holidays (whether actual and observed)].