+ Reply to Thread
Results 1 to 1 of 1

Formula required to anticipate next date - taking into account blank rows

  1. #1
    Registered User
    Join Date
    10-12-2011
    Location
    Salisbury, England
    MS-Off Ver
    Excel 2003
    Posts
    17

    Formula required to anticipate next date - taking into account blank rows

    On the attached sheet is a part time shift pattern. I want to type in the column A just the day and need a formula in coumn B to generate the correct date based on the dates in sequence above - is this possible?

    If possible I would like to separate each set of weekly dates with a blank row. There is a basic shift pattern of every Friday, every Saturday on a fortnightly basis and Sunday’s are random.

    I require the formula to exist in column B so I can run it down the column so I don't have to paste it into specific cells. This makes it very easy to add to or update.

    Thanks in advance!
    Attached Files Attached Files

+ Reply to Thread

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