Excel Formula, get the previous wednesday date
3
I have the following formula,
=WORKDAY(TODAY(),-2)
Which gets me Jan 30th.
Is there anyway I can get Jan 30th without putting the -2 in this formula? I want he formula to always get the previous Wednesdays date, but I manually just subtract the todays workday to get the previous Wednesday.
microsoft-excel
asked Feb 1 at 15:43
excelguyexcelguy
758
add a comment |
3
I have the following formula,
=WORKDAY(TODAY(),-2)
Which gets me Jan 30th.
Is there anyway I can get Jan 30th without putting the -2 in this formula? I want he formula to always get the previous Wednesdays date, but I manually just subtract the todays workday to get the previous Wednesday.
microsoft-excel
asked Feb 1 at 15:43
excelguyexcelguy
758
add a comment |
3
3
3
I have the following formula,
=WORKDAY(TODAY(),-2)
Which gets me Jan 30th.
Is there anyway I can get Jan 30th without putting the -2 in this formula? I want he formula to always get the previous Wednesdays date, but I manually just subtract the todays workday to get the previous Wednesday.
microsoft-excel
asked Feb 1 at 15:43
excelguyexcelguy
758
I have the following formula,
=WORKDAY(TODAY(),-2)
Which gets me Jan 30th.
Is there anyway I can get Jan 30th without putting the -2 in this formula? I want he formula to always get the previous Wednesdays date, but I manually just subtract the todays workday to get the previous Wednesday.
microsoft-excel
microsoft-excel
asked Feb 1 at 15:43
excelguyexcelguy
758
asked Feb 1 at 15:43
excelguyexcelguy
758
asked Feb 1 at 15:43
excelguyexcelguy
758
asked Feb 1 at 15:43
excelguyexcelguy
758
asked Feb 1 at 15:43
excelguyexcelguy
758
758
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
1
For reference, the previously accepted answer wrongly outputs future date for some scenarios
This formula outputs the previous Wednesday.
=TODAY()-MOD(WEEKDAY(TODAY())+2,7)-1
If today is Wednesday, it outputs the previous Wednesday as well.
MOD(..., 7) always returns value from 0 to 6.
So, -MOD(...)-1 always subtracts a value of 1 to 7 (days) from TODAY().
(You can adjust the value +2 in the formula to get different weekdays)
Example:
- Today is
2019-2-25 (Mon), outputs2019-2-20 (Wed)
- Today is
2019-2-26 (Tue), outputs2019-2-20 (Wed)
- Today is
2019-2-27 (Wed), outputs2019-2-20 (Wed)
- Today is
2019-2-28 (Thu), outputs2019-2-27 (Wed)
answered Feb 25 at 3:45
wilsonwilson
3,69811536
nice! this is more what I want. is there anyway to use current wednesday instead of reverting to previous?
– excelguy
Feb 25 at 14:41
yes, it will be even simpler. here you are:=TODAY()-MOD(WEEKDAY(TODAY())+3,7). theMOD(...)always return value from 0 to 6, so you can get result ranging from [today-6days] to [today].
– wilson
Feb 26 at 2:47
add a comment |
8
How about:
=TODAY() - MOD(TODAY(), 7) + 4
Which means get first day of current week (Saturday), then add 4 = Wednesday, (optionally -7 for the previous week).
If you want the previous week (if you are still in Sunday or Monday), then use if for MOD(TODAY(), 7)
answered Feb 1 at 15:52
Ahmed AshourAhmed Ashour
1,3871716
1
I'm having trouble following the explanation. Why is the first day of the current week a Saturday (as opposed to Monday or Sunday depending on what calendar system you use)? If you add 4 to a Saturday I can see that you get Wednesday, but why would -7 get you to the previous Wednesday? It seems to me that Saturday - 7 = Saturday. Note: I'm not questioning the formula, but merely the explanation that goes with it.
– Jon Bentley
Feb 1 at 18:07
@JonBentley the -7 is meant to be appended to the shown formula, not subsituted in for the +4. As to why MOD(TODAY(),7) produces this very helpful result, I'm also curious.
– Alex M
Feb 1 at 18:37
1
@AlexM Dates in excel are like an integer. Today, for example, is 43497. If you divide it by 7 using the MOD formula, will always return 6 if a day is Friday. This works because the very first day excel accepts. By dividing by 7, you guarantee that you will always get a number from 0-6 (Because 7 / 7 = 1, which returns nothing). 8/7 returns 1 for everyone and 1 not divided.
– Moacir
Feb 1 at 18:56
So now you went to the Saturday of this week(considering Saturday would be the first day), then the +4 corrects it to Wednesday
– Moacir
Feb 1 at 18:58
@Moacir thanks for the info; I suppose this is most likely fodder for a separate question, but I find it very curious (which just makes it fit with everything else about the way Excel works with dates in my experience, I guess) that though TODAY() returns the date 'formatted as a date' you're still able to use numerical operations against the underlying date value. Adding to my confusion, when I entered =MOD(TODAY(),7) into an empty cell, to test this behavior, it output 1/6/1900 - which I now understand means it returned the numeral 6 (as your formula expects), only formatted as a date.
– Alex M
Feb 1 at 19:58
|
show 2 more comments
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1401032%2fexcel-formula-get-the-previous-wednesday-date%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
1
For reference, the previously accepted answer wrongly outputs future date for some scenarios
This formula outputs the previous Wednesday.
=TODAY()-MOD(WEEKDAY(TODAY())+2,7)-1
If today is Wednesday, it outputs the previous Wednesday as well.
MOD(..., 7) always returns value from 0 to 6.
So, -MOD(...)-1 always subtracts a value of 1 to 7 (days) from TODAY().
(You can adjust the value +2 in the formula to get different weekdays)
Example:
- Today is
2019-2-25 (Mon), outputs2019-2-20 (Wed)
- Today is
2019-2-26 (Tue), outputs2019-2-20 (Wed)
- Today is
2019-2-27 (Wed), outputs2019-2-20 (Wed)
- Today is
2019-2-28 (Thu), outputs2019-2-27 (Wed)
answered Feb 25 at 3:45
wilsonwilson
3,69811536
nice! this is more what I want. is there anyway to use current wednesday instead of reverting to previous?
– excelguy
Feb 25 at 14:41
yes, it will be even simpler. here you are:=TODAY()-MOD(WEEKDAY(TODAY())+3,7). theMOD(...)always return value from 0 to 6, so you can get result ranging from [today-6days] to [today].
– wilson
Feb 26 at 2:47
add a comment |
1
For reference, the previously accepted answer wrongly outputs future date for some scenarios
This formula outputs the previous Wednesday.
=TODAY()-MOD(WEEKDAY(TODAY())+2,7)-1
If today is Wednesday, it outputs the previous Wednesday as well.
MOD(..., 7) always returns value from 0 to 6.
So, -MOD(...)-1 always subtracts a value of 1 to 7 (days) from TODAY().
(You can adjust the value +2 in the formula to get different weekdays)
Example:
- Today is
2019-2-25 (Mon), outputs2019-2-20 (Wed)
- Today is
2019-2-26 (Tue), outputs2019-2-20 (Wed)
- Today is
2019-2-27 (Wed), outputs2019-2-20 (Wed)
- Today is
2019-2-28 (Thu), outputs2019-2-27 (Wed)
answered Feb 25 at 3:45
wilsonwilson
3,69811536
nice! this is more what I want. is there anyway to use current wednesday instead of reverting to previous?
– excelguy
Feb 25 at 14:41
yes, it will be even simpler. here you are:=TODAY()-MOD(WEEKDAY(TODAY())+3,7). theMOD(...)always return value from 0 to 6, so you can get result ranging from [today-6days] to [today].
– wilson
Feb 26 at 2:47
add a comment |
1
1
1
For reference, the previously accepted answer wrongly outputs future date for some scenarios
This formula outputs the previous Wednesday.
=TODAY()-MOD(WEEKDAY(TODAY())+2,7)-1
If today is Wednesday, it outputs the previous Wednesday as well.
MOD(..., 7) always returns value from 0 to 6.
So, -MOD(...)-1 always subtracts a value of 1 to 7 (days) from TODAY().
(You can adjust the value +2 in the formula to get different weekdays)
Example:
- Today is
2019-2-25 (Mon), outputs2019-2-20 (Wed)
- Today is
2019-2-26 (Tue), outputs2019-2-20 (Wed)
- Today is
2019-2-27 (Wed), outputs2019-2-20 (Wed)
- Today is
2019-2-28 (Thu), outputs2019-2-27 (Wed)
answered Feb 25 at 3:45
wilsonwilson
3,69811536
For reference, the previously accepted answer wrongly outputs future date for some scenarios
This formula outputs the previous Wednesday.
=TODAY()-MOD(WEEKDAY(TODAY())+2,7)-1
If today is Wednesday, it outputs the previous Wednesday as well.
MOD(..., 7) always returns value from 0 to 6.
So, -MOD(...)-1 always subtracts a value of 1 to 7 (days) from TODAY().
(You can adjust the value +2 in the formula to get different weekdays)
Example:
- Today is
2019-2-25 (Mon), outputs2019-2-20 (Wed)
- Today is
2019-2-26 (Tue), outputs2019-2-20 (Wed)
- Today is
2019-2-27 (Wed), outputs2019-2-20 (Wed)
- Today is
2019-2-28 (Thu), outputs2019-2-27 (Wed)
answered Feb 25 at 3:45
wilsonwilson
3,69811536
edited Feb 26 at 2:48
answered Feb 25 at 3:45
wilsonwilson
3,69811536
answered Feb 25 at 3:45
wilsonwilson
3,69811536
answered Feb 25 at 3:45
wilsonwilson
3,69811536
3,69811536
nice! this is more what I want. is there anyway to use current wednesday instead of reverting to previous?
– excelguy
Feb 25 at 14:41
yes, it will be even simpler. here you are:=TODAY()-MOD(WEEKDAY(TODAY())+3,7). theMOD(...)always return value from 0 to 6, so you can get result ranging from [today-6days] to [today].
– wilson
Feb 26 at 2:47
add a comment |
nice! this is more what I want. is there anyway to use current wednesday instead of reverting to previous?
– excelguy
Feb 25 at 14:41
yes, it will be even simpler. here you are:=TODAY()-MOD(WEEKDAY(TODAY())+3,7). theMOD(...)always return value from 0 to 6, so you can get result ranging from [today-6days] to [today].
– wilson
Feb 26 at 2:47
nice! this is more what I want. is there anyway to use current wednesday instead of reverting to previous?
– excelguy
Feb 25 at 14:41
nice! this is more what I want. is there anyway to use current wednesday instead of reverting to previous?
– excelguy
Feb 25 at 14:41
yes, it will be even simpler. here you are:
=TODAY()-MOD(WEEKDAY(TODAY())+3,7). the MOD(...) always return value from 0 to 6, so you can get result ranging from [today-6days] to [today].– wilson
Feb 26 at 2:47
yes, it will be even simpler. here you are:
=TODAY()-MOD(WEEKDAY(TODAY())+3,7). the MOD(...) always return value from 0 to 6, so you can get result ranging from [today-6days] to [today].– wilson
Feb 26 at 2:47
add a comment |
8
How about:
=TODAY() - MOD(TODAY(), 7) + 4
Which means get first day of current week (Saturday), then add 4 = Wednesday, (optionally -7 for the previous week).
If you want the previous week (if you are still in Sunday or Monday), then use if for MOD(TODAY(), 7)
answered Feb 1 at 15:52
Ahmed AshourAhmed Ashour
1,3871716
1
I'm having trouble following the explanation. Why is the first day of the current week a Saturday (as opposed to Monday or Sunday depending on what calendar system you use)? If you add 4 to a Saturday I can see that you get Wednesday, but why would -7 get you to the previous Wednesday? It seems to me that Saturday - 7 = Saturday. Note: I'm not questioning the formula, but merely the explanation that goes with it.
– Jon Bentley
Feb 1 at 18:07
@JonBentley the -7 is meant to be appended to the shown formula, not subsituted in for the +4. As to why MOD(TODAY(),7) produces this very helpful result, I'm also curious.
– Alex M
Feb 1 at 18:37
1
@AlexM Dates in excel are like an integer. Today, for example, is 43497. If you divide it by 7 using the MOD formula, will always return 6 if a day is Friday. This works because the very first day excel accepts. By dividing by 7, you guarantee that you will always get a number from 0-6 (Because 7 / 7 = 1, which returns nothing). 8/7 returns 1 for everyone and 1 not divided.
– Moacir
Feb 1 at 18:56
So now you went to the Saturday of this week(considering Saturday would be the first day), then the +4 corrects it to Wednesday
– Moacir
Feb 1 at 18:58
@Moacir thanks for the info; I suppose this is most likely fodder for a separate question, but I find it very curious (which just makes it fit with everything else about the way Excel works with dates in my experience, I guess) that though TODAY() returns the date 'formatted as a date' you're still able to use numerical operations against the underlying date value. Adding to my confusion, when I entered =MOD(TODAY(),7) into an empty cell, to test this behavior, it output 1/6/1900 - which I now understand means it returned the numeral 6 (as your formula expects), only formatted as a date.
– Alex M
Feb 1 at 19:58
|
show 2 more comments
8
How about:
=TODAY() - MOD(TODAY(), 7) + 4
Which means get first day of current week (Saturday), then add 4 = Wednesday, (optionally -7 for the previous week).
If you want the previous week (if you are still in Sunday or Monday), then use if for MOD(TODAY(), 7)
answered Feb 1 at 15:52
Ahmed AshourAhmed Ashour
1,3871716
1
I'm having trouble following the explanation. Why is the first day of the current week a Saturday (as opposed to Monday or Sunday depending on what calendar system you use)? If you add 4 to a Saturday I can see that you get Wednesday, but why would -7 get you to the previous Wednesday? It seems to me that Saturday - 7 = Saturday. Note: I'm not questioning the formula, but merely the explanation that goes with it.
– Jon Bentley
Feb 1 at 18:07
@JonBentley the -7 is meant to be appended to the shown formula, not subsituted in for the +4. As to why MOD(TODAY(),7) produces this very helpful result, I'm also curious.
– Alex M
Feb 1 at 18:37
1
@AlexM Dates in excel are like an integer. Today, for example, is 43497. If you divide it by 7 using the MOD formula, will always return 6 if a day is Friday. This works because the very first day excel accepts. By dividing by 7, you guarantee that you will always get a number from 0-6 (Because 7 / 7 = 1, which returns nothing). 8/7 returns 1 for everyone and 1 not divided.
– Moacir
Feb 1 at 18:56
So now you went to the Saturday of this week(considering Saturday would be the first day), then the +4 corrects it to Wednesday
– Moacir
Feb 1 at 18:58
@Moacir thanks for the info; I suppose this is most likely fodder for a separate question, but I find it very curious (which just makes it fit with everything else about the way Excel works with dates in my experience, I guess) that though TODAY() returns the date 'formatted as a date' you're still able to use numerical operations against the underlying date value. Adding to my confusion, when I entered =MOD(TODAY(),7) into an empty cell, to test this behavior, it output 1/6/1900 - which I now understand means it returned the numeral 6 (as your formula expects), only formatted as a date.
– Alex M
Feb 1 at 19:58
|
show 2 more comments
8
8
8
How about:
=TODAY() - MOD(TODAY(), 7) + 4
Which means get first day of current week (Saturday), then add 4 = Wednesday, (optionally -7 for the previous week).
If you want the previous week (if you are still in Sunday or Monday), then use if for MOD(TODAY(), 7)
answered Feb 1 at 15:52
Ahmed AshourAhmed Ashour
1,3871716
How about:
=TODAY() - MOD(TODAY(), 7) + 4
Which means get first day of current week (Saturday), then add 4 = Wednesday, (optionally -7 for the previous week).
If you want the previous week (if you are still in Sunday or Monday), then use if for MOD(TODAY(), 7)
answered Feb 1 at 15:52
Ahmed AshourAhmed Ashour
1,3871716
answered Feb 1 at 15:52
Ahmed AshourAhmed Ashour
1,3871716
answered Feb 1 at 15:52
Ahmed AshourAhmed Ashour
1,3871716
answered Feb 1 at 15:52
Ahmed AshourAhmed Ashour
1,3871716
1,3871716
1
I'm having trouble following the explanation. Why is the first day of the current week a Saturday (as opposed to Monday or Sunday depending on what calendar system you use)? If you add 4 to a Saturday I can see that you get Wednesday, but why would -7 get you to the previous Wednesday? It seems to me that Saturday - 7 = Saturday. Note: I'm not questioning the formula, but merely the explanation that goes with it.
– Jon Bentley
Feb 1 at 18:07
@JonBentley the -7 is meant to be appended to the shown formula, not subsituted in for the +4. As to why MOD(TODAY(),7) produces this very helpful result, I'm also curious.
– Alex M
Feb 1 at 18:37
1
@AlexM Dates in excel are like an integer. Today, for example, is 43497. If you divide it by 7 using the MOD formula, will always return 6 if a day is Friday. This works because the very first day excel accepts. By dividing by 7, you guarantee that you will always get a number from 0-6 (Because 7 / 7 = 1, which returns nothing). 8/7 returns 1 for everyone and 1 not divided.
– Moacir
Feb 1 at 18:56
So now you went to the Saturday of this week(considering Saturday would be the first day), then the +4 corrects it to Wednesday
– Moacir
Feb 1 at 18:58
@Moacir thanks for the info; I suppose this is most likely fodder for a separate question, but I find it very curious (which just makes it fit with everything else about the way Excel works with dates in my experience, I guess) that though TODAY() returns the date 'formatted as a date' you're still able to use numerical operations against the underlying date value. Adding to my confusion, when I entered =MOD(TODAY(),7) into an empty cell, to test this behavior, it output 1/6/1900 - which I now understand means it returned the numeral 6 (as your formula expects), only formatted as a date.
– Alex M
Feb 1 at 19:58
|
show 2 more comments
1
I'm having trouble following the explanation. Why is the first day of the current week a Saturday (as opposed to Monday or Sunday depending on what calendar system you use)? If you add 4 to a Saturday I can see that you get Wednesday, but why would -7 get you to the previous Wednesday? It seems to me that Saturday - 7 = Saturday. Note: I'm not questioning the formula, but merely the explanation that goes with it.
– Jon Bentley
Feb 1 at 18:07
@JonBentley the -7 is meant to be appended to the shown formula, not subsituted in for the +4. As to why MOD(TODAY(),7) produces this very helpful result, I'm also curious.
– Alex M
Feb 1 at 18:37
1
@AlexM Dates in excel are like an integer. Today, for example, is 43497. If you divide it by 7 using the MOD formula, will always return 6 if a day is Friday. This works because the very first day excel accepts. By dividing by 7, you guarantee that you will always get a number from 0-6 (Because 7 / 7 = 1, which returns nothing). 8/7 returns 1 for everyone and 1 not divided.
– Moacir
Feb 1 at 18:56
So now you went to the Saturday of this week(considering Saturday would be the first day), then the +4 corrects it to Wednesday
– Moacir
Feb 1 at 18:58
@Moacir thanks for the info; I suppose this is most likely fodder for a separate question, but I find it very curious (which just makes it fit with everything else about the way Excel works with dates in my experience, I guess) that though TODAY() returns the date 'formatted as a date' you're still able to use numerical operations against the underlying date value. Adding to my confusion, when I entered =MOD(TODAY(),7) into an empty cell, to test this behavior, it output 1/6/1900 - which I now understand means it returned the numeral 6 (as your formula expects), only formatted as a date.
– Alex M
Feb 1 at 19:58
1
1
I'm having trouble following the explanation. Why is the first day of the current week a Saturday (as opposed to Monday or Sunday depending on what calendar system you use)? If you add 4 to a Saturday I can see that you get Wednesday, but why would -7 get you to the previous Wednesday? It seems to me that Saturday - 7 = Saturday. Note: I'm not questioning the formula, but merely the explanation that goes with it.
– Jon Bentley
Feb 1 at 18:07
I'm having trouble following the explanation. Why is the first day of the current week a Saturday (as opposed to Monday or Sunday depending on what calendar system you use)? If you add 4 to a Saturday I can see that you get Wednesday, but why would -7 get you to the previous Wednesday? It seems to me that Saturday - 7 = Saturday. Note: I'm not questioning the formula, but merely the explanation that goes with it.
– Jon Bentley
Feb 1 at 18:07
@JonBentley the -7 is meant to be appended to the shown formula, not subsituted in for the +4. As to why MOD(TODAY(),7) produces this very helpful result, I'm also curious.
– Alex M
Feb 1 at 18:37
@JonBentley the -7 is meant to be appended to the shown formula, not subsituted in for the +4. As to why MOD(TODAY(),7) produces this very helpful result, I'm also curious.
– Alex M
Feb 1 at 18:37
1
1
@AlexM Dates in excel are like an integer. Today, for example, is 43497. If you divide it by 7 using the MOD formula, will always return 6 if a day is Friday. This works because the very first day excel accepts. By dividing by 7, you guarantee that you will always get a number from 0-6 (Because 7 / 7 = 1, which returns nothing). 8/7 returns 1 for everyone and 1 not divided.
– Moacir
Feb 1 at 18:56
@AlexM Dates in excel are like an integer. Today, for example, is 43497. If you divide it by 7 using the MOD formula, will always return 6 if a day is Friday. This works because the very first day excel accepts. By dividing by 7, you guarantee that you will always get a number from 0-6 (Because 7 / 7 = 1, which returns nothing). 8/7 returns 1 for everyone and 1 not divided.
– Moacir
Feb 1 at 18:56
So now you went to the Saturday of this week(considering Saturday would be the first day), then the +4 corrects it to Wednesday
– Moacir
Feb 1 at 18:58
So now you went to the Saturday of this week(considering Saturday would be the first day), then the +4 corrects it to Wednesday
– Moacir
Feb 1 at 18:58
@Moacir thanks for the info; I suppose this is most likely fodder for a separate question, but I find it very curious (which just makes it fit with everything else about the way Excel works with dates in my experience, I guess) that though TODAY() returns the date 'formatted as a date' you're still able to use numerical operations against the underlying date value. Adding to my confusion, when I entered =MOD(TODAY(),7) into an empty cell, to test this behavior, it output 1/6/1900 - which I now understand means it returned the numeral 6 (as your formula expects), only formatted as a date.
– Alex M
Feb 1 at 19:58
@Moacir thanks for the info; I suppose this is most likely fodder for a separate question, but I find it very curious (which just makes it fit with everything else about the way Excel works with dates in my experience, I guess) that though TODAY() returns the date 'formatted as a date' you're still able to use numerical operations against the underlying date value. Adding to my confusion, when I entered =MOD(TODAY(),7) into an empty cell, to test this behavior, it output 1/6/1900 - which I now understand means it returned the numeral 6 (as your formula expects), only formatted as a date.
– Alex M
Feb 1 at 19:58
|
show 2 more comments
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- 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.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1401032%2fexcel-formula-get-the-previous-wednesday-date%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
