+ Reply to Thread
Results 1 to 1 of 1

I want this calender to be split 2 days 2 nights and move forward when you change the year

  1. #1
    Registered User
    Join Date
    05-02-2018
    Location
    derby, uk
    MS-Off Ver
    2010
    Posts
    2

    I want this calender to be split 2 days 2 nights and move forward when you change the year

    Hi, hopefully the workbook is attached. if you change the date from 2012 to 2018 the shift pattern moves to correspond to the new date. I'd like this this form instead of 4 days then 4 nights for each colour I would like it to be 2 days 2 nights and the shift pattern to move forward when the date is changed as per the original workbook. Good luck I haven't got a scooby do as I work with spanners and hammers, and any help would be greatly appreciated.
    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)

Similar Threads

  1. Year wise cumulative split of days
    By vijayca in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-07-2018, 06:03 AM
  2. Calculate Date from Year. Months and Days (Forward and Backward both)
    By Premmadaan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-25-2017, 05:45 AM
  3. Replies: 3
    Last Post: 06-04-2014, 07:35 AM
  4. Replies: 2
    Last Post: 11-18-2013, 12:22 PM
  5. Convert a multiple year list of 365 days/year into an equivalent of 360 days/year
    By lobotomy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2012, 05:39 PM
  6. Calculating Weeks, Weekday nights and Weekend nights
    By bngguy in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-26-2010, 01:41 PM
  7. time:DAYS or NIGHTS
    By whitesidehasdon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2007, 10:47 PM

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