Date Format for days 01-12 are americanized

jcrennan · #7 09-07-2015, 08:40 PM

Quote:

Originally Posted by NoSparks

jcrennan

Can you post a sample file with user form which behaves this way ?

Also, what is the setting of Short Date in your regional settings ?

I have attached an empty copy

If you goto the Totals Worksheet and use Add Entry button this will bring up the form.
When you click the Add record button on the form the details from the user form get added to the Programs Worksheet.

To test select an entry that is in the 1st twelve days on the month and then also do an entry for one that is in the later part of the month.

The PC regional settings is English(Australia) Short Date d/MM/yyyy

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to count even exact date 90 days	redza	Excel	1	09-17-2013 03:36 AM
Date Field to add 10 Days to Current Date	Erbwon	Word	6	11-12-2012 06:17 PM
Set calendar alarm x days before end date	el_ja	Outlook	2	01-19-2012 10:09 AM
30+ days Variable Day Date Calculations via Fields	ztag	Word	2	01-06-2012 11:12 AM
Creating an Auto-Calc'd Date? Today+7 Days?	SoCalTelephone	Word	0	10-06-2010 10:27 AM