date to text

  1. D

    Excel VBA Date in wrong format

    I need to export data from a excel file to a CSV file (to use for import in MailChimp) using VBA. I have dates in columns and in excel (* .xlsm) dates are correct, but after they are copied to * .CSV and I open the * CSV file again, some dates are not correct. I have checked that all cells in...
  2. J

    Count occurrences of data according to date from a different sheet

    I will try to explain this as best I can please bare with me. Here is the situation I have: On the first sheet (for the sake of this post we will call Sheet1) I have a list of multiple items in one column which are dates formatted as such: month-day-year Also on Sheet1 I have another column...
  3. R

    Dates in Excel

    I am a new user here, but an avid Excel user. Great site BTW. Love it. Quite helpful in many ways. Here is my question. I am working with dates and trying to convert the date to a text month so I can run a formula to add a column to insert quarters (Q1, Q2, Q3, Q4). I have been using...

Watch MrExcel Video

This Week's Hot Topics

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
Top