Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62

    Unanswered: Data validation for the Date in cell.

    Hello,
    I have a cell that Formated to accept Date in the (mm/dd/yyyy) format.
    But when I test it, it accepts text as well and may sho incorrect data.

    How to fix it, so user may only enter the Date in the correct format?

    Thank you,

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Formatting does not affect data entry.

    Rather, select the cell, then go to Data > Validation. In the drop down choose "Date" and it will give you possible beginning and ending dates. Now everything entered has to be Date. Also, you have a pop-up error message, if you select the last tab "Error Alert".
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62
    Ok, Thank you,

    its working, but I still have a Q?.
    How to choose possible beginning and ending dates?
    It is an order form, so the day needs to be current and going forward.
    Confuzed on that too. I placed the "grater than", but not sure if it is correct.

    Thank you for your help!

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Actually, in validation, it doesn't matter. I would choose the beginning of this year as the starting date. It won't matter about changing.

    Unless you don't want someone to choose a date prior to the current date. In that case, then in the starting date, put this:

    =TODAY()
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62
    Yes, you are right,
    I do not want a user to choose a date prior than the current date.
    How to go arown this problem?

  6. #6
    Join Date
    Oct 2003
    Posts
    1,091
    If you use

    =TODAY()

    in the Starting from box, then it will only allow whatever today's date is and after. For ending Date, if you want it to be moving as well, then in the ending date, put this:

    =TODAY()

    This will allow only the current date. If you want it to go forward 30 days, then

    =TODAY()+30
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  7. #7
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62
    Thank you for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •