software

This is hard to explain but i will try
If i have cells B1:Z1 with the formula
=weekday(B2)inB1, then =B1 1 inC1 etc, B2:Z2 with dates of the month
(1/1/2006 etc) And B3:Z3 with in in in in out out in in in in out
out... etc (a 4days in 2 days out work pattern) and all the out are
highlighted green through conditional format.
When you come to the beginning of the year 2007 the two days out
should be SUN/MON (31st-1st) amp; then SAT/SUN (6th-7th)
Is there any way of getting the in/out cells to move forward when
you change the year from 2006 to 2007
Hope somebody can understand this or i can forward
a sample of what i am trying to do
THANKS--
Caveman
------------------------------------------------------------------------
Caveman's Profile: www.excelforum.com/member.php...oamp;userid=27546
View this thread: www.excelforum.com/showthread...hreadid=492817You can set a field in your workbook some where for a date parameter. The
date parameter quot;TL_Oridequot; is the date you'd like the series to begin. This
can be a value like 1/1/2006 or a calculated amount like =TODAY()-2

Then, have your first date cell in the series hold this formula.

=IF(TL_Oride=quot;quot;,TODAY()-7,TL_Oride)

The next field in the series would follow the 1 as you noted you are
already using.

quot;Cavemanquot; wrote:

gt;
gt; This is hard to explain but i will try
gt; If i have cells B1:Z1 with the formula
gt; =weekday(B2)inB1, then =B1 1 inC1 etc, B2:Z2 with dates of the month
gt; (1/1/2006 etc) And B3:Z3 with in in in in out out in in in in out
gt; out... etc (a 4days in 2 days out work pattern) and all the out are
gt; highlighted green through conditional format.
gt; When you come to the beginning of the year 2007 the two days out
gt; should be SUN/MON (31st-1st) amp; then SAT/SUN (6th-7th)
gt; Is there any way of getting the in/out cells to move forward when
gt; you change the year from 2006 to 2007
gt; Hope somebody can understand this or i can forward
gt; a sample of what i am trying to do
gt; THANKS
gt;
gt;
gt; --
gt; Caveman
gt; ------------------------------------------------------------------------
gt; Caveman's Profile: www.excelforum.com/member.php...oamp;userid=27546
gt; View this thread: www.excelforum.com/showthread...hreadid=492817
gt;
gt;