What is the easiest way to check if a week is between two dates?
To explain: I have a sheet with 2 dates for example 23-08-2018 and 10-01-2019. They have the labels StartDate and EndDate.
The thing i am struggleing with is the following.
I need to write a function (boolean) that takes 3 variables: week, startDate and EndDate and then check if the dates contains that week. Does anyone know how to do this? Or can give me a push in the right direction...
Example: Week = 22, StartDate = 22-03-2018 , EndDate = 22-09-2018
Output: True
Explaination: If even one day of the range StartDate - EndDate is within the week is should be true.
Example: Week = 5, StartDate = 22-03-2018 , EndDate = 22-09-2018
Output: False
Explaination: week 5 is from 29-01-2018 to 04-02-2018 so its outside the start and endDate range.
excel vba excel-vba
asked Nov 22 at 18:19
Rhett van Korlaar
11
|
show 3 more comments
To explain: I have a sheet with 2 dates for example 23-08-2018 and 10-01-2019. They have the labels StartDate and EndDate.
The thing i am struggleing with is the following.
I need to write a function (boolean) that takes 3 variables: week, startDate and EndDate and then check if the dates contains that week. Does anyone know how to do this? Or can give me a push in the right direction...
Example: Week = 22, StartDate = 22-03-2018 , EndDate = 22-09-2018
Output: True
Explaination: If even one day of the range StartDate - EndDate is within the week is should be true.
Example: Week = 5, StartDate = 22-03-2018 , EndDate = 22-09-2018
Output: False
Explaination: week 5 is from 29-01-2018 to 04-02-2018 so its outside the start and endDate range.
excel vba excel-vba
asked Nov 22 at 18:19
Rhett van Korlaar
11
1
Can you please edit your question to add sample data and expected output. Among other things people are likely to wonder about: what happens is a given week starts before but ends within the given date range?
– cybernetic.nomad
Nov 22 at 18:25
Thanks for your answer i hope this is somewhat more clear
– Rhett van Korlaar
Nov 22 at 18:35
1
try the weeknum() function on a given date
– Solar Mike
Nov 22 at 18:38
The problem isnt converting from date to weeknumer. i can do that with Format(date, "ww"). The problem is checkig if a week is between 2 dates.
– Rhett van Korlaar
Nov 22 at 18:43
You can use mathematical inequalities once you have the weeknumber to determine whether or not it's between the bounds you have set
– Brotato
Nov 22 at 19:15
|
show 3 more comments
To explain: I have a sheet with 2 dates for example 23-08-2018 and 10-01-2019. They have the labels StartDate and EndDate.
The thing i am struggleing with is the following.
I need to write a function (boolean) that takes 3 variables: week, startDate and EndDate and then check if the dates contains that week. Does anyone know how to do this? Or can give me a push in the right direction...
Example: Week = 22, StartDate = 22-03-2018 , EndDate = 22-09-2018
Output: True
Explaination: If even one day of the range StartDate - EndDate is within the week is should be true.
Example: Week = 5, StartDate = 22-03-2018 , EndDate = 22-09-2018
Output: False
Explaination: week 5 is from 29-01-2018 to 04-02-2018 so its outside the start and endDate range.
excel vba excel-vba
asked Nov 22 at 18:19
Rhett van Korlaar
11
To explain: I have a sheet with 2 dates for example 23-08-2018 and 10-01-2019. They have the labels StartDate and EndDate.
The thing i am struggleing with is the following.
I need to write a function (boolean) that takes 3 variables: week, startDate and EndDate and then check if the dates contains that week. Does anyone know how to do this? Or can give me a push in the right direction...
Example: Week = 22, StartDate = 22-03-2018 , EndDate = 22-09-2018
Output: True
Explaination: If even one day of the range StartDate - EndDate is within the week is should be true.
Example: Week = 5, StartDate = 22-03-2018 , EndDate = 22-09-2018
Output: False
Explaination: week 5 is from 29-01-2018 to 04-02-2018 so its outside the start and endDate range.
excel vba excel-vba
excel vba excel-vba
asked Nov 22 at 18:19
Rhett van Korlaar
11
asked Nov 22 at 18:19
Rhett van Korlaar
11
edited Nov 22 at 18:35
asked Nov 22 at 18:19
Rhett van Korlaar
11
asked Nov 22 at 18:19
Rhett van Korlaar
11
asked Nov 22 at 18:19
Rhett van Korlaar
11
11
1
Can you please edit your question to add sample data and expected output. Among other things people are likely to wonder about: what happens is a given week starts before but ends within the given date range?
– cybernetic.nomad
Nov 22 at 18:25
Thanks for your answer i hope this is somewhat more clear
– Rhett van Korlaar
Nov 22 at 18:35
1
try the weeknum() function on a given date
– Solar Mike
Nov 22 at 18:38
The problem isnt converting from date to weeknumer. i can do that with Format(date, "ww"). The problem is checkig if a week is between 2 dates.
– Rhett van Korlaar
Nov 22 at 18:43
You can use mathematical inequalities once you have the weeknumber to determine whether or not it's between the bounds you have set
– Brotato
Nov 22 at 19:15
|
show 3 more comments
1
Can you please edit your question to add sample data and expected output. Among other things people are likely to wonder about: what happens is a given week starts before but ends within the given date range?
– cybernetic.nomad
Nov 22 at 18:25
Thanks for your answer i hope this is somewhat more clear
– Rhett van Korlaar
Nov 22 at 18:35
1
try the weeknum() function on a given date
– Solar Mike
Nov 22 at 18:38
The problem isnt converting from date to weeknumer. i can do that with Format(date, "ww"). The problem is checkig if a week is between 2 dates.
– Rhett van Korlaar
Nov 22 at 18:43
You can use mathematical inequalities once you have the weeknumber to determine whether or not it's between the bounds you have set
– Brotato
Nov 22 at 19:15
1
1
Can you please edit your question to add sample data and expected output. Among other things people are likely to wonder about: what happens is a given week starts before but ends within the given date range?
– cybernetic.nomad
Nov 22 at 18:25
Can you please edit your question to add sample data and expected output. Among other things people are likely to wonder about: what happens is a given week starts before but ends within the given date range?
– cybernetic.nomad
Nov 22 at 18:25
Thanks for your answer i hope this is somewhat more clear
– Rhett van Korlaar
Nov 22 at 18:35
Thanks for your answer i hope this is somewhat more clear
– Rhett van Korlaar
Nov 22 at 18:35
1
1
try the weeknum() function on a given date
– Solar Mike
Nov 22 at 18:38
try the weeknum() function on a given date
– Solar Mike
Nov 22 at 18:38
The problem isnt converting from date to weeknumer. i can do that with Format(date, "ww"). The problem is checkig if a week is between 2 dates.
– Rhett van Korlaar
Nov 22 at 18:43
The problem isnt converting from date to weeknumer. i can do that with Format(date, "ww"). The problem is checkig if a week is between 2 dates.
– Rhett van Korlaar
Nov 22 at 18:43
You can use mathematical inequalities once you have the weeknumber to determine whether or not it's between the bounds you have set
– Brotato
Nov 22 at 19:15
You can use mathematical inequalities once you have the weeknumber to determine whether or not it's between the bounds you have set
– Brotato
Nov 22 at 19:15
|
show 3 more comments
active
oldest
votes
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%2f53436390%2fwhat-is-the-easiest-way-to-check-if-a-week-is-between-two-dates%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53436390%2fwhat-is-the-easiest-way-to-check-if-a-week-is-between-two-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
1
Can you please edit your question to add sample data and expected output. Among other things people are likely to wonder about: what happens is a given week starts before but ends within the given date range?
– cybernetic.nomad
Nov 22 at 18:25
Thanks for your answer i hope this is somewhat more clear
– Rhett van Korlaar
Nov 22 at 18:35
1
try the weeknum() function on a given date
– Solar Mike
Nov 22 at 18:38
The problem isnt converting from date to weeknumer. i can do that with Format(date, "ww"). The problem is checkig if a week is between 2 dates.
– Rhett van Korlaar
Nov 22 at 18:43
You can use mathematical inequalities once you have the weeknumber to determine whether or not it's between the bounds you have set
– Brotato
Nov 22 at 19:15