-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
dd/mm/yyyy
-
O
Force cell entry strictly to mm/dd/yyyy
Using Excel 2007, and I want to force entry to calls in a date column to the format mm/dd/yyyy. Currently I have the cells formatted for mm/dd/yyyy and entered data validation date range between 12/31/1999 and 12/31/2060. However some users are too lazy to look up the day case start and just...- odonnell
- Thread
- date dd/mm/yyyy format cell validation date
- Replies: 7
- Forum: Excel Questions
-
M
Calculating average time with a dd/mm/yyyy hh/mm notation
Hey all, I'm new here and I have an Excel question which is probably very easy for you. I have row of times in the dd/mm/yyyy hh/mm notation. If I calculate the average by =average(A1;A3;A5) it all goes well but at a (for me random) date the average isn't correct any more. It probably has to...- Maurits
- Thread
- average dd/mm/yyyy hh/mm time
- Replies: 7
- Forum: Excel Questions
-
I
Date format in VBA
Dim dtMdate As Date dtMdate = Format(rs.Fields("Mdate"), "yyyymmdd") Debug.print dtMdate But when I print the above variable in my Intermeditate window I got the values like debug.Print dtmdate 00:00:00 instead of date value like dd/mm/yyyy Am I using wrong way to use format mask...- imfarhan
- Thread
- date dd/mm/yyyy format
- Replies: 6
- Forum: Microsoft Access
-
Date Validation in Text Box
Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am having problems with this have read a few threads but cant seem to get it to work I have a textbox on a user form and I want to make sure the date is in dd/mm/yy. If it isn’t I want a...- melewie
- Thread
- date dd/mm/yyyy format text box
- Replies: 4
- Forum: Excel Questions
