Excel Dates issue

Posted on 2014-08-15
Last Modified: 2014-08-15
Hi. I have a list of 800 dates in Excel that I am trying to load to a database. The problem
is that most dates are not recognized as dates using the "IsDate" function unless
I manually type the date like the first one in the list. How can I convert all these dates
so my code recognizes them as dates?

28 September 2010
Question by:murbro
    LVL 47

    Assisted Solution


    You could type 1 in another cell,  copy it and paste special Multiply to convert them to dates

    LVL 24

    Accepted Solution

    you could convert the dates to '234' notation using TEXT which seems to be easily read by databases etc...

    =TEXT(CellWithDate,"dd mmm yyyy")
    LVL 31

    Assisted Solution

    by:Rob Henson
    Steve, to get the full date as per the example given, you would need "dd mmmm yyyy".

    "dd mmm yyyy" would only give "28 Sept 2010" rather than "28 September 2010".

    Rob H

    Author Closing Comment

    Thank you all for the help
    LVL 24

    Expert Comment

    rob, my suggestion wasn't to get to the full date, but to a date which tends to be accepted on uploads.
    The '234' date format is not effected by region and seems to work on almost any upload, being recognised as a date.
    I tend to use it in most up-down transfers.
    (but yes, 244 is just as valid, but takes up unnecessary space)

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now