Hi,
As you can see from the enclosed image, I have a list of dates in a
column, the top date is always today's date, regardless of when the
spreadsheet is opened, which I arranged by using the TODAY() function,
and the other dates are today's date plus 1, plus 2, plus 3, etc.
Therefore the dates are moving up the list, day by day. The Saturdays
are linked to the correct dates using the IF(WEEKDAY(F4)=7,"Saturday",
"") function, and so on, so they are moving up the table, too.
I want the boxes that seperate the weeks to move up with the dates, so
that there is always a line between the Fridays and Saturdays.
The ordinary Format / Border function will not do, as then the borders
are fixed. I want the horizantal lines to move up the table, day by
day.
Is this possible? Any help would be much appreciated
Thanks
Spike
+-------------------------------------------------------------------+
|Filename: dates.jpg |
|Download:
http://www.excelforum.com/attachment.php?postid=4055 |
+-------------------------------------------------------------------+
--
SpikeUK
------------------------------------------------------------------------
SpikeUK's Profile:
http://www.excelforum.com/member.php...o&userid=28997
View this thread:
http://www.excelforum.com/showthread...hreadid=487264