-
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.
mm/yyyy
-
N
How to Data Validate Cell Format to: MM/YEAR - MM/YEAR
Happy Friday! I'm trying to force users to input a date range in the format of MM/YEAR - MM/YEAR into a specific cell (B1). I tried using Data Validation but I received the "..value doesn't match..", error alert when testing it out. I selected the Custom option and typed MM/YYYY - MM/YYYY in the...- NEW_2VBA
- Thread
- data format mm/year mm/yyyy validation
- Replies: 4
- Forum: Excel Questions
-
S
Trouble Changing date Formats
Good Morning All I have a datasheet that looks at health interventions in an organisation. A data feed I receive populates the datasheet with the dates on which these interventions happen and I calculate the next due date of the intervention for an individual - nothing complicated, quite...- Simonc64
- Thread
- changing complicated datasheet date mm/yyyy
- Replies: 1
- Forum: Excel Questions
-
A
Copy from range
HI!!! Sub getSum() Dim strDate As String Dim ws As Worksheet strDate = InputBox("Insert date in format mm/yyyy", "User date", Format(Now(), "mm/yyyy")) If IsDate(strDate) Then strDate = Format(CDate(strDate), "mm/yyyy") Else MsgBox "Wrong date format. Please try again." Exit Sub End If Dim...- arijitirf
- Thread
- dim long mm/yyyy mumps thismonth
- Replies: 3
- Forum: Excel Questions
-
A
Sum a range based on other range criteria for all sheets
Hi!!!! Sub getSum() Dim strDate As String Dim ws As Worksheet strDate = InputBox("Insert date in format mm/yyyy", "User date", Format(Now(), "mm/yyyy")) If IsDate(strDate) Then strDate = Format(CDate(strDate), "mm/yyyy") Else MsgBox "Wrong date format. Please try again." Exit Sub End If Dim...- arijitirf
- Thread
- date dim long mm/yyyy thismonth
- Replies: 0
- Forum: Excel Questions
