+ Reply to Thread
Results 1 to 5 of 5

Dynamic dates range extend to the associated cells

Hybrid View

  1. #1
    Registered User
    Join Date
    06-22-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2021
    Posts
    62

    Dynamic dates range extend to the associated cells

    Hello all,

    I am seeking some help, I have a range of 10 cells with dynamic dates and in the cells below dates have some codes associated with each day of the week for my dynamic dates. What I am looking for is, as the dynamic dates changes on each day the codes shall be changed too. For clear idea I have attached screen shot and the file that explains in detail. Any help is highly appreciated.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by razaas; 12-26-2011 at 03:40 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Dynamic dates range extend to the associated cells

    Not entirely sure I follow - would help to have a variety of examples (for variety of dates), however...

    Based on sample - given the repetitive nature of the index it might be wise to store 1 to 10 in a single row and then adapt output results accordingly using this as value as suffix ?

    e.g.

    A2:
    =TEXT(A$1,"ddd")
    copied to J2
    
    A19:
    =WEEKDAY(A$1,1)+5*(COUNTIF($A$2:A$2,A$2)-1)
    copied to J19
    Then

    A3:
    =CHOOSE(ROW(A3)-ROW(A$2),"V","N","LC","HV","HNV","HLC")&A$19
    copied across matrix A3:J8
    use of row 19 purely for demo - can be wherever simplify modify reference to $19 accordingly

  3. #3
    Registered User
    Join Date
    06-22-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2021
    Posts
    62

    Re: Dynamic dates range extend to the associated cells

    DonkeyOte,

    Thanks a million, that is perfect. Have a great day.

    Regards,
    Raza

  4. #4
    Registered User
    Join Date
    06-22-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2021
    Posts
    62

    Re: Dynamic dates range extend to the associated cells

    Sorry, at my initial check I didn't notice that the second set of week days which is 2nd sun, 2nd mon and so on...are not showing the correct code which is V6, V7 ......

    It is repeating the same codes from V1 to V5 for 1st or 2nd set of days. Appreciate help.

  5. #5
    Registered User
    Join Date
    06-22-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2021
    Posts
    62

    Re: Dynamic dates range extend to the associated cells

    Quote Originally Posted by razaas View Post
    Sorry, at my initial check I didn't notice that the second set of week days which is 2nd sun, 2nd mon and so on...are not showing the correct code which is V6, V7 ......

    It is repeating the same codes from V1 to V5 for 1st or 2nd set of days. Appreciate help.
    Sorry I made mistake in my original file, it is working fine, thanks again.

+ 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