Results 1 to 4 of 4

Difficult Excel Problem

Threaded View

SpikeUK Difficult Excel Problem 11-22-2005, 11:58 AM
Guest RE: Difficult Excel Problem 11-22-2005, 12:25 PM
SpikeUK Thank you for that, that's a... 11-22-2005, 02:34 PM
SpikeUK Since your help was so useful... 11-22-2005, 07:31 PM
  1. #1
    Registered User
    Join Date
    11-22-2005
    Posts
    8

    Difficult Excel Problem

    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
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1