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...

Some videos you may like

This Week's Hot Topics