Format Date along with Text

J

Joe

Cell A1 contains the date: December 31, 2008
I want cell A2 to display "Dec Before"
I tried =A1&" Before" which returned: 39813 Before
I tried =(MONTH(A1))&" Before" which returned: 12 Before
I can format the date as Dec just fine until I add the &" Before" to it.
When I add the &" Before" in the formula it forces the Dec to read as 12. How
do I force the 12 back to read Dec?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign each week number to corresponding month of the year 5
Calendar Logic: Recurring Dates 3
2 dimensional date sort 2
Calculating quarters of a year. 4
How to get Holidays in cell/s? (Find explaination in details) 3
Detailed Countdown 2
Lookup function 1
If statements 1

Top