Two dates and text in one cell

[jonathan92591]

Hello everyone,

This is my first post. I've used this web forum for almost a year now. It's really helpful. Helped me finish my MBA and helps me with my current positions as a data analyst for one company and as a business consultant for another. So, thank you.

--



Hello everyone,

Two dates and text in one cell

--

Excel or Access version: Excel 2010

Computer operating system: Windows XP

Sample data: No sample data

Formula(s) right now: =TODAY()-7&" through "&TODAY()-1 (Cell is marked as date)

Current result(s): 40836 through 40842

My goal: I need to fit two dates and text in one cell. It’s one of the headings for my report. And each week I create a report that looks at the last 7 days of activity. To make the report as efficient as possible, I’d this to be automated. And also prevent errors. So if I could do this, one cell would look this “10/20 through 10/26” and it would automatically populate when I opened the file.

Error message: No error message

How error occurred: No error message

Generated in: Excel

Thank you.

JT

 

[Jonmo1]

Welcome to the board.

Great post by the way, provided all relevant information...
Good to see some people read the forum guidelines.


You need to use the Text function on the dates to formt the date.

Try

=TEXT(TODAY()-7,"mm/dd")&" through "&TEXT(TODAY()-1,"mm/dd")


Hope that helps.

 

[jonathan92591]

Welcome to the board.

Great post by the way, provided all relevant information...
Good to see some people read the forum guidelines.


You need to use the Text function on the dates to formt the date.

Try

=TEXT(TODAY()-7,"mm/dd")&" through "&TEXT(TODAY()-1,"mm/dd")


Hope that helps.

Thank you. I've learned to always read the instruction manual first. You'll decrease the learning curve and you'll find out cool stuff you would never have discovered.

I created a form in Excel, it's tailored to my needs, but basically it allows me simply open a file as a form, fill it out, I always use red as "change" and blue as "could change." Just copy and paste into the thread builder. It's that painless. I'd like to share the file with everyone but I'll make a separate post and if anyone wants it, they can either have mine or at least be inspired to make their own. I viewed your profile and saw the Excel Jeanie. Within 3 minutes I knew how to use it and it's awesome! Great find. Thanks for sharing. For example, here is my Excel form I intend to use if I make a post to this Excel forum.

Excel Workbook
	A	B
1	Hello everyone,	*
2	*	*
3	Title of your post	*
4	*	*
5	--	*
6	*	*
7	Excel or Access version:	Excel 2010
8	*	*
9	Computer operating system:	Windows XP
10	*	*
11	Sample data:	No sample data
12	*	*
13	Formula(s) right now:	*
14	*	*
15	Current result(s):	*
16	*	*
17	My goal:	*
18	*	*
19	Error message:	No error message
20	*	*
21	How error occurred:	No error message
22	*	*
23	Generated in:	Excel
24	*	*
25	Thank you.	*
26	*	*
27	JT :)	*
Sheet2

Back to the purpose of this thread, you're awesome! Thank you very much kind sir. I virtually extend you a beer. So rad, I've been hacking at that for some time, I never thought to change the cell type to text! I will remember this solution for future endeavours.

Thank you again.

JT

--

This question has been solved.

 

[Jonmo1]

Glad to help, thanks for the feedback.