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
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;
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
asked Mar 26 at 18:56
MaykidMaykid
1121 silver badge12 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
asked Mar 26 at 18:56
MaykidMaykid
1121 silver badge12 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
asked Mar 26 at 18:56
MaykidMaykid
1121 silver badge12 bronze badges
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
excel excel-formula
asked Mar 26 at 18:56
MaykidMaykid
1121 silver badge12 bronze badges
asked Mar 26 at 18:56
MaykidMaykid
1121 silver badge12 bronze badges
edited Mar 26 at 19:41
Maykid
asked Mar 26 at 18:56
MaykidMaykid
1121 silver badge12 bronze badges
asked Mar 26 at 18:56
MaykidMaykid
1121 silver badge12 bronze badges
asked Mar 26 at 18:56
MaykidMaykid
1121 silver badge12 bronze badges
1121 silver badge12 bronze badges
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
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))),"")
edited Mar 26 at 19:59
Maykid
1121 silver badge12 bronze badges
answered Mar 26 at 19:37
tigeravatartigeravatar
23.4k4 gold badges23 silver badges36 bronze badges
This did it perfectly thank you!!
– Maykid
Mar 26 at 19:46
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.
edited Mar 26 at 20:55
Bob Dalgleish
6,7022 gold badges26 silver badges38 bronze badges
answered Mar 26 at 19:31
KrysteelKrysteel
613 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
);
);
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
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
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
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))),"")
edited Mar 26 at 19:59
Maykid
1121 silver badge12 bronze badges
answered Mar 26 at 19:37
tigeravatartigeravatar
23.4k4 gold badges23 silver badges36 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))),"")
edited Mar 26 at 19:59
Maykid
1121 silver badge12 bronze badges
answered Mar 26 at 19:37
tigeravatartigeravatar
23.4k4 gold badges23 silver badges36 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))),"")
edited Mar 26 at 19:59
Maykid
1121 silver badge12 bronze badges
answered Mar 26 at 19:37
tigeravatartigeravatar
23.4k4 gold badges23 silver badges36 bronze badges
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))),"")
edited Mar 26 at 19:59
Maykid
1121 silver badge12 bronze badges
answered Mar 26 at 19:37
tigeravatartigeravatar
23.4k4 gold badges23 silver badges36 bronze badges
edited Mar 26 at 19:59
Maykid
1121 silver badge12 bronze badges
edited Mar 26 at 19:59
Maykid
1121 silver badge12 bronze badges
edited Mar 26 at 19:59
Maykid
1121 silver badge12 bronze badges
1121 silver badge12 bronze badges
answered Mar 26 at 19:37
tigeravatartigeravatar
23.4k4 gold badges23 silver badges36 bronze badges
answered Mar 26 at 19:37
tigeravatartigeravatar
23.4k4 gold badges23 silver badges36 bronze badges
answered Mar 26 at 19:37
tigeravatartigeravatar
23.4k4 gold badges23 silver badges36 bronze badges
23.4k4 gold badges23 silver badges36 bronze badges
This did it perfectly thank you!!
– Maykid
Mar 26 at 19:46
add a comment |
This did it perfectly thank you!!
– Maykid
Mar 26 at 19:46
This did it perfectly thank you!!
– Maykid
Mar 26 at 19:46
This did it perfectly thank you!!
– Maykid
Mar 26 at 19:46
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.
edited Mar 26 at 20:55
Bob Dalgleish
6,7022 gold badges26 silver badges38 bronze badges
answered Mar 26 at 19:31
KrysteelKrysteel
613 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.
edited Mar 26 at 20:55
Bob Dalgleish
6,7022 gold badges26 silver badges38 bronze badges
answered Mar 26 at 19:31
KrysteelKrysteel
613 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.
edited Mar 26 at 20:55
Bob Dalgleish
6,7022 gold badges26 silver badges38 bronze badges
answered Mar 26 at 19:31
KrysteelKrysteel
613 bronze badges
You can use an if statement similar to
if(edate(range)>Today(),return this data,0)
Insert your data for return this data.
edited Mar 26 at 20:55
Bob Dalgleish
6,7022 gold badges26 silver badges38 bronze badges
answered Mar 26 at 19:31
KrysteelKrysteel
613 bronze badges
edited Mar 26 at 20:55
Bob Dalgleish
6,7022 gold badges26 silver badges38 bronze badges
edited Mar 26 at 20:55
Bob Dalgleish
6,7022 gold badges26 silver badges38 bronze badges
edited Mar 26 at 20:55
Bob Dalgleish
6,7022 gold badges26 silver badges38 bronze badges
6,7022 gold badges26 silver badges38 bronze badges
answered Mar 26 at 19:31
KrysteelKrysteel
613 bronze badges
answered Mar 26 at 19:31
KrysteelKrysteel
613 bronze badges
answered Mar 26 at 19:31
KrysteelKrysteel
613 bronze badges
613 bronze badges
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
