It worked, it is awsome, thank you so much.
brian

"Bryan Hessey" wrote:


well, (after reading your question) - - - To start at A2, use

=IF(MONTH(OFFSET(A$1,D$1-3+ROW(),0))<MONTH(C$1),"",OFFSET(A$1,D$1-3+ROW(),0))

and drag to row 17

--

Bryan Hessey Wrote:
The attached file shows a method of calculating and extracting a single
month of working days under your 4-on 4-off system, commencing from the
2nd April. You can amend the first 4 dates to suit your needs, the rest
should be automatic. (to go beyond 2012 just drag the formula in A and
B further down)

The format works if, on another sheet you enter,
in C1 a first of the month date,
in D1 =MATCH(C1,Sheet2!B:B,0)
in E1 or A1

=IF(MONTH(OFFSET(Sheet2!A$1,D$1-2+ROW(),0))<MONTH(C$1),"",OFFSET(Sheet2!A$1,D$1-2+ROW(),0))

and drag down to row 16
(? 17 is not possible?)

I presume that you can adjust this to your needs.

attached:
http://www.excelforum.com/attachment...6&d=1145410120

--


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533965