VBA DATE format check in xlsM

perform those checks and pop up a message to the user based on value of Cel D6

Case 1

Day must be 16 or 1 for example 04/01/2015 is not valid must be either 16/01/2015 or 1/02/2015

Pop up Message: Start Day must be 1 or 16 of the month!


Date value from cel D6 must be at least 2 weeks before todays date

Pop up Message: Your request must be sent 2 weeks before start date!


D6 cannot be null

Pop up Message : You must insert a start date!


D6 date format must be dd/mm/yyyy like 16/01/2015

Pop up Message : Date format must be dd/mm/yyyy!

Every time D6 value WRONG and don’t pass the checks cursor goes back to cell D6 and D6 is clear

If D6 value is correct then user can do whatever.

There are 2 options that you can use:

That can be done when a button is pressed OR on lost focus or after update one or the other is good.

I would prefer a lost focus or after update

Give back a xlsm

Skills: Excel, Visual Basic

See more: vba time, lost excel, insert date, vba update excel, vba pass, excel insert value, excel format cell, excel month correct, format cell, excel vba cell, checks excel, good format excel, vba excel format date, msaccess format date vba, format date vba, excel vba update, excel vba todays date, date vba excel, powerpoint vba format date, excel format date

About the Employer:
( 40 reviews ) brussels, Belgium

Project ID: #6877218

Awarded to:


Hello, I am an expert in Excel VBA and just successfully completed a Excel VBA project to the employers satisfaction. I have worked on many very complicated excel VBAs. I am new to this site and want to build reputatio More

$12 USD in 1 day
(1 Review)

12 freelancers are bidding on average $29 for this job


A proposal has not yet been provided

$30 USD in 1 day
(165 Reviews)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More

$25 USD in 0 days
(87 Reviews)

Hello sir,I have 8 member team and good experience and we can start the work right now and also all communication and work will be high quality. all work will be on my office without any [login to view URL]

$24 USD in 1 day
(79 Reviews)

very simple excel VBA macro !

$19 USD in 1 day
(100 Reviews)

Propunerea nu a fost încă furnizată

$30 USD in 0 days
(49 Reviews)

Hello, I can get this task done in the next 2 hours or so. Let me know if you are interested. Thanks

$25 USD in 0 days
(20 Reviews)


$30 USD in 1 day
(6 Reviews)

Greetings for the Day!!! i have 5 years of experience in Data entry and typing , Excel macro, VB script and VB application creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, M More

$15 USD in 1 day
(7 Reviews)

Hi I'm an IT student with good knowledge in excel and macro. I will do my best for you if you consider me. Kindly check my review and my portfolio and let me know if you interested in good job. regards

$20 USD in 1 day
(6 Reviews)

Good day! I'am the GOD of vba! Ready to do it right now! I'll perform your task perfectly! Have a lot of experience in similar tasks.(2 years working in the bank) If you have any questions, please feel free to ask.

$15 USD in 1 day
(1 Review)

We have extensive industry experience and knowledge. Please see profile for details. With us, QUALITY is GUARANTEED.

$100 USD in 5 days
(1 Review)

A proposal has not yet been provided

$15 USD in 1 day
(0 Reviews)