Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dating Problem (Excel 2002)

    The attached spreadsheet is used to track our backup tapes. All weekly schedules for backup tapes begin with Thursday being Day 1. In column A I have the date, followed by a modified weekday function to get rid of weekends. What I would like to know if there is some coding so that when I enter the date in A2, that it would automatically fill in the 20 day cycle, but exclude dates for weekends. In other words enter the two dates for Thurs/Fri, skip the weekend dates, add dates for the next week, skip the weekend, etc.
    Thanks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Dating Problem (Excel 2002)

    In A3 enter:
    =A2+1+(WEEKDAY(A2)=6)*2
    copy this down the column.

    The formula increments 1 cell from the cell above it + it adds 2 if the day above is Firday. Change A2 and all the others calculate correctly

    Note: If you format column A (format -cells - number (tab) custom) to:
    ddd m/d/yyyy

    or even (my preference)
    ddd mmm d, yyyy

    It will display the day of the week and the date without the extra columns, calculations, and lookups.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dating Problem (Excel 2002)

    Thanks. Does exactly what I need.

Posting Permissions

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