+ Reply to Thread
Results 1 to 4 of 4

hi i have a problem what i need to add to an existing array formula to add a dynamic date?

  1. 02-16-2014, 02:29 PM #1
    andygraham
    andygraham is offline
    Registered User
    Join Date
    02-15-2014
    Location
    shropshire,england
    MS-Off Ver
    Excel 2007
    Posts
    4

    hi i have a problem what i need to add to an existing array formula to add a dynamic date?

    I ve been set the task at work to make the original work rota into a dynamic one. With the daily date running along the top and names running
    down the left and with the shift pattern each are on in the middle. iv managed to make a dynamic table to ectract the info I need for the first
    column only which = the 01/01/2014 what I want is to access the data from the 02/01/14 etc. So have to make dynamic date cell! PLEASE can anyone help??????
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-16-2014, 02:48 PM #2
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: hi i have a problem what i need to add to an existing array formula to add a dynamic d

    Try this version date dropdown in K1
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 02-17-2014, 10:23 AM #3
    andygraham
    andygraham is offline
    Registered User
    Join Date
    02-15-2014
    Location
    shropshire,england
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: hi i have a problem what i need to add to an existing array formula to add a dynamic d

    Fantastic thank you very much. Sorry for posting it twice.
    Reply With QuoteRegister To Reply
  4. 02-17-2014, 10:48 AM #4
    andygraham
    andygraham is offline
    Registered User
    Join Date
    02-15-2014
    Location
    shropshire,england
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: hi i have a problem what i need to add to an existing array formula to add a dynamic d

    http://www.excelforum.com/reputation...tion&p=3588017
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need Help inserting dynamic "date" into formula array.
    By andygraham in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2014, 10:41 AM
  2. Excel dynamic array problem
    By darby88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2012, 08:18 AM
  3. Help with existing array formula
    By Greed in forum Excel General
    Replies: 3
    Last Post: 09-15-2011, 11:39 AM
  4. Problem: dynamic array from range.
    By Mark K in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2006, 02:41 AM
  5. Dynamic Array problem
    By Werner in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-17-2005, 01:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1