dates as text

  1. J

    Excel values incorrectly convert to 5 digit number

    Hello everyone! I am having the toughest time formatting a spreadsheet with copy pasted data. For my purposes, I require all formatting to be "removed"; that "9/6, 12/1, 5/6", et al are not seen as dates, however like they are manually entered values with no format. Because Excel is thinking...
  2. N

    Using SumIF on Dates Stored as Text in Column Headers

    Using Excel 2016 I have a dataset which has dates in row 1. when the range is converted into a Table, row 1 becomes my table headers and excel treats all column headers as Text regardless of the previous data type. I have the following formula which when the dataset is stored as a range, and...
  3. G

    Return the most recent date

    I am working with a range of dates that tasks were completed. However some of the cells are blank because the tasks are in process. I need a formula to return the most recent date indicated in the rage once all of the cells in the range have completed dates by them. GG
  4. S

    How to extract month from a date that's in Text format?

    I have a column with the following values: <tbody> SubmitDate November 8, 2012 1:37:07 PM GMT+05:30 November 8, 2012 9:32:03 AM GMT+05:30 November 8, 2012 4:32:54 AM GMT+05:30 November 7, 2012 10:28:11 PM GMT+05:30 November 7, 2012 8:36:43 PM GMT+05:30 November 7, 2012 6:33:13 AM...
  5. P

    Using a different cells date for conditional formatting

    I feel like this is a pretty simple question to answer but I cant find an answer to it anywhere or I'm just not skilled enough to understand it. I have two columns D and E that have dates in them. Column D is the purchase date of a computer and column E is how many years months and days its...
  6. C

    Workday Formula

    Hi, I'm setting up some workbooks for the new financial year 2012-13 and I've got a problem with a workdays formula that has worked perfectly well for this current year, 2011-12. Here is the formula...
  7. R

    Dates imported as text?

    When I import a report into Excel, often the dates come over and some of them are text while others are recognized dates. I think it because the order of the months and days is not what Excel is expecting. See image: Does anyone know the best way to fix this in Excel as oppose to on the...
  8. D

    Formating a date as text in a macro

    Could someone help me please. Below is an example entry in a single cell. I am parsing the different elements out into separate columns. 16 Aug Payment to xxx Type of payment yyy Amount £zzz<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> The...
  9. L

    COUNTIFS dates match, dates as numeric but in text cell with many other numbers

    Hi, again thanks for previous help, I would not ask had I not tried several times already, but my new question is this: I have a column listed as the ID tag for a dataset. This column has a large number for every row, with numbers representing different values of the identification, and...

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