Export Dates to Excel RRS feed

  • Question

  • Hi All

    Another basic question (!)...

    How can I export date information from (MSP2013) into excel in 'date' format rather than 'text' format ????

    Help !!!!


    Swansea Jack

    Thursday, September 12, 2013 10:23 AM

All replies

  • Hi Jack

    When you say MSP2013 do you mean Project Online? As far as I know, this option is not available when you get the Data fom oData feed. Depending on what you want to do, there are different ways to organize the informaton and to show it as date.

    Can you please tell us which are your needs, so we may give you some alternatives.

    Raphael |

    Thursday, September 12, 2013 11:47 AM
  • Hi Raphael

    Thanks for replying. I'm using MSProject 2013 and I want to copy dates from Project and paste them into excel (becuase that's how we report progress). However, the dates from MSProject always seem to come across as text format and I need to be able to filter on them when I get them into excel (this may be a question for the excel forum!!)

    Any help much appreciated.

    Hwyl !

    Swansea Jack

    Thursday, September 12, 2013 12:34 PM
  • Jack

    I think I can help you. Let´s try the following steps:

    1. After copying the information into Excel, you see the Dates as Fri 09/12/2013 (depending on the format you are using). Let´s say that the Dates are placed on Column B2
    2. Click in an available Column and inser this formula: =Value(Right(B2,8))
    3. This formula will extract only the Dates and convert them into numbers, which are what you need
    4. Use the Formatting feature to show the Dates in a format you wish
    5. Finally, copy the Dates on column B and then use Paste Special > Values - overwritting the original Dates you have copied

    I think this would solve your problem

    Let me know if you have any questions. |

    Thursday, September 12, 2013 1:24 PM
  • Hi

    The problem is the date comes across from MSProject in the following format ....  "12 Sep '13" ... and this is not recognised in excel as a valid 'date' format. I have found a way of manipulating it in excel but it's a bit of a faff and wonder if there is an easier way to to do.


    Swansea Jack

    Thursday, September 12, 2013 2:18 PM