concatenate date

  1. K

    Formatting Date to MM-DD-YY while using CONCATENATE

    Hello everyone, I am having difficulties with a date properly formatting while I am using the CONCATENATE formula. I have a date in cell B1, which is formatted correctly, and there are also multiple unrelated cells from B2 - B10 that are "input" cells. I am using A15 to with a concatenate...
    • kbdavis11
    • Thread
    • concatenate concatenate date concatenate formatting date date formatting
    • Replies: 2
    • Forum: Excel Questions
  2. M

    Concatenate Text with Date plus an IF field that will include date

    Hi, I have a start date and an end date. Sometimes the end date is blank. I want the end date to read Pres if there is no date. =""&TEXT(E2,"yyyy")&" - "&IF(F2="","Pres",F2) F2 is the end date - so it part way works: 2005 - Pres if F2 is blank. But if it isn't blank how can I get it to...
    • maloney12
    • Thread
    • concatenate date concatenate if text & numbers in a cell
    • Replies: 3
    • Forum: Excel Questions
  3. C

    Concatenate Dates with leading zeroes

    I need to take a date format from a database dump and Concatenate it into a new cell to format it the way I need so I can perform calculations. I have the calculations working but I need to figure out how to insert leading zeroes for single-digit months and years so that all dates end up with...
  4. G

    How do I turn a date into text?

    In cells D1, E1, and F1 I have the following dates: Jan-12, Feb-12, and Mar-12. In cells J2, K2, and L2 I have the following formulas: J2 ="Sales $ "&D1 K2 ="Sales $ "&E1 L2 ="Sales $ "&F1 The problem is that the result I'm getting in J2 is NOT "Sales $ Jan-12" but rather...
  5. I

    another time date issue

    i have several million records that need to be modified. when i try to concatenate it always converts time to decimal if orignal D1 or E1 has a date but works if time only. Original import from text- Columns C= init date/time, D=Connect date/time, E=Disconnect time column C1= date.time (...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top