validate date

  1. B

    Validate data input in DD/MM/YYYY hh:mm format

    Hi all, I'm looking to use data validation to throw an error if inputted format is not DD/MM/YYYY hh:mm. This is a standard excel format but I can't wrap my head around how to validate, can anyone help please? Assume the input is in cell A2. Thank you.
  2. Grizlore

    Suggestions for the most elegant solution for inserting dates into a Userform (avoid Calendar Controls)

    Hi All, (Happy New Year!) I wish to totally avoid the use of Calendar controls, as I have experienced many issues with them as I need to provide a solution for Users who use several different versions of Excel. I have a Userform which needs two dates. The first is normally the current date...
  3. T

    Validate Dates using VBA

    I have a table ("Open Orders") with a column ("Date Paid"). If there is a date in the Date Paid column then I have a macro that removes that record from the table. What I want to do is use code that determines if any of the dates that have been entered are not equal to today's date. If they are...

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
Back
Top