Stringing together a sentence from data that includes dates
I have a question regarding this topic;
I'm also looking to put together a string of data into a sentence using excel, and the issue I'm running into involves dates.
="ISP Annual was completed on "&('(1) Checklists 1'!E12)& " as an "&'(1) Checklists 1'!H12&" investigation." is my equation, where the'(1) Checklists 1'!E12 would normally resource a date into the sentence. Resourcing it alone creates a date, but when I try the above equation, it converts it into a serial number "43151." I've tried DATEVALUE to remedy it, but it breaks the equation. Is there an easier way to do this?
Resource question that I have reviewed in an attempt to understand an answer:
Make sentence from data in cells in Excel
excel date format equation sentence
asked Jan 3 at 15:40
Chris FigluizziChris Figluizzi
83
add a comment |
I have a question regarding this topic;
I'm also looking to put together a string of data into a sentence using excel, and the issue I'm running into involves dates.
="ISP Annual was completed on "&('(1) Checklists 1'!E12)& " as an "&'(1) Checklists 1'!H12&" investigation." is my equation, where the'(1) Checklists 1'!E12 would normally resource a date into the sentence. Resourcing it alone creates a date, but when I try the above equation, it converts it into a serial number "43151." I've tried DATEVALUE to remedy it, but it breaks the equation. Is there an easier way to do this?
Resource question that I have reviewed in an attempt to understand an answer:
Make sentence from data in cells in Excel
excel date format equation sentence
asked Jan 3 at 15:40
Chris FigluizziChris Figluizzi
83
1
Use theTEXTfunction to format the date when concatenating.
– BigBen
Jan 3 at 15:40
Thank you Big Ben; it worked like a charm.
– Chris Figluizzi
Jan 3 at 15:47
add a comment |
I have a question regarding this topic;
I'm also looking to put together a string of data into a sentence using excel, and the issue I'm running into involves dates.
="ISP Annual was completed on "&('(1) Checklists 1'!E12)& " as an "&'(1) Checklists 1'!H12&" investigation." is my equation, where the'(1) Checklists 1'!E12 would normally resource a date into the sentence. Resourcing it alone creates a date, but when I try the above equation, it converts it into a serial number "43151." I've tried DATEVALUE to remedy it, but it breaks the equation. Is there an easier way to do this?
Resource question that I have reviewed in an attempt to understand an answer:
Make sentence from data in cells in Excel
excel date format equation sentence
asked Jan 3 at 15:40
Chris FigluizziChris Figluizzi
83
I have a question regarding this topic;
I'm also looking to put together a string of data into a sentence using excel, and the issue I'm running into involves dates.
="ISP Annual was completed on "&('(1) Checklists 1'!E12)& " as an "&'(1) Checklists 1'!H12&" investigation." is my equation, where the'(1) Checklists 1'!E12 would normally resource a date into the sentence. Resourcing it alone creates a date, but when I try the above equation, it converts it into a serial number "43151." I've tried DATEVALUE to remedy it, but it breaks the equation. Is there an easier way to do this?
Resource question that I have reviewed in an attempt to understand an answer:
Make sentence from data in cells in Excel
excel date format equation sentence
excel date format equation sentence
asked Jan 3 at 15:40
Chris FigluizziChris Figluizzi
83
asked Jan 3 at 15:40
Chris FigluizziChris Figluizzi
83
asked Jan 3 at 15:40
Chris FigluizziChris Figluizzi
83
asked Jan 3 at 15:40
Chris FigluizziChris Figluizzi
83
asked Jan 3 at 15:40
Chris FigluizziChris Figluizzi
83
83
1
Use theTEXTfunction to format the date when concatenating.
– BigBen
Jan 3 at 15:40
Thank you Big Ben; it worked like a charm.
– Chris Figluizzi
Jan 3 at 15:47
add a comment |
1
Use theTEXTfunction to format the date when concatenating.
– BigBen
Jan 3 at 15:40
Thank you Big Ben; it worked like a charm.
– Chris Figluizzi
Jan 3 at 15:47
1
1
Use the
TEXT function to format the date when concatenating.– BigBen
Jan 3 at 15:40
Use the
TEXT function to format the date when concatenating.– BigBen
Jan 3 at 15:40
Thank you Big Ben; it worked like a charm.
– Chris Figluizzi
Jan 3 at 15:47
Thank you Big Ben; it worked like a charm.
– Chris Figluizzi
Jan 3 at 15:47
add a comment |
0
active
oldest
votes
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%2f54025449%2fstringing-together-a-sentence-from-data-that-includes-dates%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
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.
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%2f54025449%2fstringing-together-a-sentence-from-data-that-includes-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
Use the
TEXTfunction to format the date when concatenating.– BigBen
Jan 3 at 15:40
Thank you Big Ben; it worked like a charm.
– Chris Figluizzi
Jan 3 at 15:47