Styjun

Request for a Latin phrase as motto "God is highest/supreme"

Why was Sauron preparing for war instead of trying to find the ring?

Is there a list of words that will enable the second player in two-player Ghost to always win?

What is the most efficient way to write 'for' loops in Matlab?

How to check what is edible on an alien world?

Copying an existing HTML page and use it, is that against any copyright law?

Use cases for M-0 & C-0?

How many oliphaunts died in all of the Lord of the Rings battles?

Did the meaning of "significant" change in the 20th century?

Is there a wealth gap in Boston where the median net worth of white households is $247,500 while the median net worth for black families was $8?

Catan Victory points

Sci fi story: Clever pigs that help a galaxy lawman

What language is Raven using for her attack in the new 52?

If a 2019 UA artificer has the Repeating Shot infusion on two hand crossbows, can they use two-weapon fighting?

Word for showing a small part of something briefly to hint to its existence or beauty without fully uncovering it

Examples of simultaneous independent breakthroughs

Melee or Ranged attacks by Monsters, no distinction in modifiers?

Do the books ever say oliphaunts aren’t elephants?

Craving for food?

Why is it considered Acid Rain with pH <5.6

How can I write an interdental lateral in phonetic transcription?

What is the difference between position, displacement, and distance traveled?

Can a table be formatted so that math mode is in some columns and text is in others by default?

Are the named pipe created by `mknod` and the FIFO created by `mkfifo` equivalent?

How do I only get future dates only instead of future and past dates?

How to conditional format Excel 2010 to trigger flag icon in new column, based on due datesExcel VBA paste data to column based on criteriaCOUNTIFS across two sheetsINDEX and SMALL only returning one result'If Then' loop with copy and pasteTrying to verify date on sheet1 in one cell with 30 columns on sheet 2 once verified with vba data pastes under date in sheet2#NUM! error when formula calculating % complete for future datesArray function in Excel that returns any date from column A where the row meets all three criteria in column GMinimum-Date per Criteria using Excel FormulaHow to pull data from one excel sheet to another based on multiple criteria

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

So this is the issue that I'm facing. Currently I'm running into an issue with a piece of my code. What I'm looking for is to only grab things that haven't reached a specific end date and if it's already ended do not grab, but currently it's grabbing everything.

I've tried doing some IF statements for example:

=IF('Sheet1'!$G:$G>TODAY(),IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF('Sheet1'!$E:$E=$B$1,ROW('Sheet1'!$E:$E)-MIN(ROW('Sheet1'!$E:$E))+1),ROWS('Sheet1'!$D$2:D2))),""),"")

NOTE: This is an Array

But running this still gives me Category's that have already past the End Date.

For Column Reference:

Sheet1 Column D = Category

Sheet1 Column E = Name

Sheet1 Column G = End Date

B1 = Name of person (Currently a drop down list of multiple names)

The Current code I have without the IF statement is as follows: (Again Array)

=IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF('Sheet1'!$E:$E=$B$1,ROW('Sheet1'!$E:$E)-MIN(ROW('Sheet1'!$E:$E))+1),ROWS('Sheet1'!$D$2:D2))),"")

What I want it to result in is if the End Date is in the past to essentially skip over and move onto the next criteria instead of grabbing it based of TODAY() function. With the result of only capturing future Category's with future End Dates.

Any help would be much appreciated!

-Maykid

excel excel-formula

share|improve this question

edited Mar 26 at 19:41

Maykid

asked Mar 26 at 18:56

MaykidMaykid

11211 silver badge1212 bronze badges

add a comment | 

1

So this is the issue that I'm facing. Currently I'm running into an issue with a piece of my code. What I'm looking for is to only grab things that haven't reached a specific end date and if it's already ended do not grab, but currently it's grabbing everything.

I've tried doing some IF statements for example:

=IF('Sheet1'!$G:$G>TODAY(),IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF('Sheet1'!$E:$E=$B$1,ROW('Sheet1'!$E:$E)-MIN(ROW('Sheet1'!$E:$E))+1),ROWS('Sheet1'!$D$2:D2))),""),"")

NOTE: This is an Array

But running this still gives me Category's that have already past the End Date.

For Column Reference:

Sheet1 Column D = Category

Sheet1 Column E = Name

Sheet1 Column G = End Date

B1 = Name of person (Currently a drop down list of multiple names)

The Current code I have without the IF statement is as follows: (Again Array)

=IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF('Sheet1'!$E:$E=$B$1,ROW('Sheet1'!$E:$E)-MIN(ROW('Sheet1'!$E:$E))+1),ROWS('Sheet1'!$D$2:D2))),"")

What I want it to result in is if the End Date is in the past to essentially skip over and move onto the next criteria instead of grabbing it based of TODAY() function. With the result of only capturing future Category's with future End Dates.

Any help would be much appreciated!

-Maykid

excel excel-formula

share|improve this question

edited Mar 26 at 19:41

Maykid

asked Mar 26 at 18:56

MaykidMaykid

11211 silver badge1212 bronze badges

add a comment | 

So this is the issue that I'm facing. Currently I'm running into an issue with a piece of my code. What I'm looking for is to only grab things that haven't reached a specific end date and if it's already ended do not grab, but currently it's grabbing everything.

I've tried doing some IF statements for example:

=IF('Sheet1'!$G:$G>TODAY(),IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF('Sheet1'!$E:$E=$B$1,ROW('Sheet1'!$E:$E)-MIN(ROW('Sheet1'!$E:$E))+1),ROWS('Sheet1'!$D$2:D2))),""),"")

NOTE: This is an Array

But running this still gives me Category's that have already past the End Date.

For Column Reference:

Sheet1 Column D = Category

Sheet1 Column E = Name

Sheet1 Column G = End Date

B1 = Name of person (Currently a drop down list of multiple names)

The Current code I have without the IF statement is as follows: (Again Array)

=IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF('Sheet1'!$E:$E=$B$1,ROW('Sheet1'!$E:$E)-MIN(ROW('Sheet1'!$E:$E))+1),ROWS('Sheet1'!$D$2:D2))),"")

What I want it to result in is if the End Date is in the past to essentially skip over and move onto the next criteria instead of grabbing it based of TODAY() function. With the result of only capturing future Category's with future End Dates.

Any help would be much appreciated!

-Maykid

excel excel-formula

share|improve this question

edited Mar 26 at 19:41

Maykid

asked Mar 26 at 18:56

MaykidMaykid

11211 silver badge1212 bronze badges

=IF('Sheet1'!$G:$G>TODAY(),IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF('Sheet1'!$E:$E=$B$1,ROW('Sheet1'!$E:$E)-MIN(ROW('Sheet1'!$E:$E))+1),ROWS('Sheet1'!$D$2:D2))),""),"")

=IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF('Sheet1'!$E:$E=$B$1,ROW('Sheet1'!$E:$E)-MIN(ROW('Sheet1'!$E:$E))+1),ROWS('Sheet1'!$D$2:D2))),"")

share|improve this question

edited Mar 26 at 19:41

Maykid

asked Mar 26 at 18:56

MaykidMaykid

11211 silver badge1212 bronze badges

share|improve this question

edited Mar 26 at 19:41

Maykid

asked Mar 26 at 18:56

MaykidMaykid

11211 silver badge1212 bronze badges

asked Mar 26 at 18:56

MaykidMaykid

11211 silver badge1212 bronze badges

asked Mar 26 at 18:56

MaykidMaykid

11211 silver badge1212 bronze badges

2 Answers
2

active

oldest

votes

2

As an array formula:

=IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF(('Sheet1'!$E:$E='Sheet1'!$B$1)*('Sheet1'!$G:$G>TODAY())>0,ROW('Sheet1'!$D:$D)),ROW(A1))),"")

share|improve this answer

edited Mar 26 at 19:59

Maykid

11211 silver badge1212 bronze badges

answered Mar 26 at 19:37

tigeravatartigeravatar

23.4k44 gold badges2323 silver badges3636 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This did it perfectly thank you!!
  
  – Maykid
  Mar 26 at 19:46
  

  
  
  
  

add a comment | 

0

You can use an if statement similar to

if(edate(range)>Today(),return this data,0)

Insert your data for return this data.

share|improve this answer

edited Mar 26 at 20:55

Bob Dalgleish

6,70222 gold badges2626 silver badges3838 bronze badges

answered Mar 26 at 19:31

KrysteelKrysteel

6133 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55364451%2fhow-do-i-only-get-future-dates-only-instead-of-future-and-past-dates%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

As an array formula:

=IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF(('Sheet1'!$E:$E='Sheet1'!$B$1)*('Sheet1'!$G:$G>TODAY())>0,ROW('Sheet1'!$D:$D)),ROW(A1))),"")

share|improve this answer

edited Mar 26 at 19:59

Maykid

11211 silver badge1212 bronze badges

answered Mar 26 at 19:37

tigeravatartigeravatar

23.4k44 gold badges2323 silver badges3636 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This did it perfectly thank you!!
  
  – Maykid
  Mar 26 at 19:46
  

  
  
  
  

add a comment | 

2

As an array formula:

=IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF(('Sheet1'!$E:$E='Sheet1'!$B$1)*('Sheet1'!$G:$G>TODAY())>0,ROW('Sheet1'!$D:$D)),ROW(A1))),"")

share|improve this answer

edited Mar 26 at 19:59

Maykid

11211 silver badge1212 bronze badges

answered Mar 26 at 19:37

tigeravatartigeravatar

23.4k44 gold badges2323 silver badges3636 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This did it perfectly thank you!!
  
  – Maykid
  Mar 26 at 19:46
  

  
  
  
  

add a comment | 

As an array formula:

=IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF(('Sheet1'!$E:$E='Sheet1'!$B$1)*('Sheet1'!$G:$G>TODAY())>0,ROW('Sheet1'!$D:$D)),ROW(A1))),"")

share|improve this answer

edited Mar 26 at 19:59

Maykid

11211 silver badge1212 bronze badges

answered Mar 26 at 19:37

tigeravatartigeravatar

23.4k44 gold badges2323 silver badges3636 bronze badges

=IFERROR(INDEX('Sheet1'!$D:$D,SMALL(IF(('Sheet1'!$E:$E='Sheet1'!$B$1)*('Sheet1'!$G:$G>TODAY())>0,ROW('Sheet1'!$D:$D)),ROW(A1))),"")

share|improve this answer

edited Mar 26 at 19:59

Maykid

11211 silver badge1212 bronze badges

answered Mar 26 at 19:37

tigeravatartigeravatar

23.4k44 gold badges2323 silver badges3636 bronze badges

edited Mar 26 at 19:59

Maykid

11211 silver badge1212 bronze badges

edited Mar 26 at 19:59

Maykid

11211 silver badge1212 bronze badges

answered Mar 26 at 19:37

tigeravatartigeravatar

23.4k44 gold badges2323 silver badges3636 bronze badges

answered Mar 26 at 19:37

tigeravatartigeravatar

23.4k44 gold badges2323 silver badges3636 bronze badges

0

You can use an if statement similar to

if(edate(range)>Today(),return this data,0)

Insert your data for return this data.

share|improve this answer

edited Mar 26 at 20:55

Bob Dalgleish

6,70222 gold badges2626 silver badges3838 bronze badges

answered Mar 26 at 19:31

KrysteelKrysteel

6133 bronze badges

add a comment | 

0

You can use an if statement similar to

if(edate(range)>Today(),return this data,0)

Insert your data for return this data.

share|improve this answer

edited Mar 26 at 20:55

Bob Dalgleish

6,70222 gold badges2626 silver badges3838 bronze badges

answered Mar 26 at 19:31

KrysteelKrysteel

6133 bronze badges

add a comment | 

You can use an if statement similar to

if(edate(range)>Today(),return this data,0)

Insert your data for return this data.

share|improve this answer

edited Mar 26 at 20:55

Bob Dalgleish

6,70222 gold badges2626 silver badges3838 bronze badges

answered Mar 26 at 19:31

KrysteelKrysteel

6133 bronze badges

if(edate(range)>Today(),return this data,0)

share|improve this answer

edited Mar 26 at 20:55

Bob Dalgleish

6,70222 gold badges2626 silver badges3838 bronze badges

answered Mar 26 at 19:31

KrysteelKrysteel

6133 bronze badges

edited Mar 26 at 20:55

Bob Dalgleish

6,70222 gold badges2626 silver badges3838 bronze badges

edited Mar 26 at 20:55

Bob Dalgleish

6,70222 gold badges2626 silver badges3838 bronze badges

answered Mar 26 at 19:31

KrysteelKrysteel

6133 bronze badges

answered Mar 26 at 19:31

KrysteelKrysteel

6133 bronze badges