+ Reply to Thread
Results 1 to 4 of 4

Generate a range of values between specific dates

  1. 05-28-2021, 09:19 AM #1
    cameronw87
    cameronw87 is offline
    Registered User
    Join Date
    05-28-2021
    Location
    Lancaster, Pennsylvania
    MS-Off Ver
    2007
    Posts
    2

    Generate a range of values between specific dates

    Good morning Excel community!

    I am working on creating a timeline feature for an ML dataset that predicts sales amounts. The feature that is giving me trouble is the holiday value. I would like to create a date related value that would hold a value of 1.00 for selected holidays, and then gradually (maybe in 0.125 increments) drop to 0 before and after.Attachment 734499 Looking something like the file image. I could do this manually but this would be time consuming and inefficient going back several years.
    Attached Files Attached Files
    Last edited by cameronw87; 05-28-2021 at 10:57 AM.
    Reply With QuoteRegister To Reply
  2. 05-28-2021, 09:42 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,522

    Re: Generate a range of values between specific dates

    Answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Reply With QuoteRegister To Reply
  3. 05-28-2021, 10:56 AM #3
    cameronw87
    cameronw87 is offline
    Registered User
    Join Date
    05-28-2021
    Location
    Lancaster, Pennsylvania
    MS-Off Ver
    2007
    Posts
    2

    Re: Generate a range of values between specific dates

    Apologies. File has been attached.
    Reply With QuoteRegister To Reply
  4. 05-28-2021, 11:32 AM #4
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,522

    Re: Generate a range of values between specific dates

    In I2

    0.125

    in I3

    =IFERROR(IF(MATCH([@Date],Table1[Date],0),1),IF(COUNTIF($J$2:J2,1)=0,J2+0.125,J2-0.125))
    Attached Files Attached Files
    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. [SOLVED] Generate range of dates from a given period
    By archvanarl in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 08-14-2021, 11:19 AM
  2. [SOLVED] Generate specific range of Uniq ramdon from a main range
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2014, 06:23 PM
  3. [SOLVED] Macro to generate a random number between 2 specific values into specific cells.
    By Nerfmagnet in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-10-2013, 11:45 AM
  4. Count values in a range that appear for specific dates
    By galvinpaddy in forum Excel General
    Replies: 1
    Last Post: 11-02-2011, 03:45 PM
  5. VBA - Generate Date Range Within 2 Supplied Dates (Modified)
    By AErmie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2009, 06:49 AM
  6. VBA - Generate Date Range Within 2 Supplied Dates
    By AErmie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2009, 08:49 AM
  7. Generate Calendar with Specific Dates Marked
    By emullark in forum Excel General
    Replies: 10
    Last Post: 01-07-2009, 05:16 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