date format issue

I am trying to extract a date from a text string and write it to another column is a spreadsheet. The date is in the input string in col A and I want to extract this date and write it to col F in the format dd/mm/yy. In the code below, at the line Cells(c, "f").Value = str1, str1 shows the...

Problem: My formula to lookup (using INDEX / MATCH) to pull in date values from one workbook to another appears to be working correctly, but some dates just pull in and convert to zero and I'm not sure why? What I'm trying to do: Is save time rather than copy manually all these over. The...

Hello guys, I got date format from third party program like in the below pictures. 2023 = years 03 = month 22 = date 01 = hours time 13 = minute 50 = secs I have tried to change date format to Short format, Custom format. But it always show like in the Cell A1. Could you help me to change...

Hi, guys. I have built a spreadsheet to control rotation of crews but for some reason it is behaving oddly depending on the computer it is opened. Whenever I open it in a computer with laguange set in Portuguese the flights are not returning the pax list unless I have to change the date format...

I'm getting outputs from an auto-generating report in the following format. Excel recognizes it as "General" and I'm struggling to convert it to a recognizable date format. Don't care about the time stamp (MM/DD/YYYY would work). Any help is really appreciated! Mar 01 2020 00:00:00 Apr 19...

Hi All, I have a huge list of dates that I need to sort based on the month. However, I am unable to format some of the dates, no matter whatever format I chose in Excel. Below, I have provided a sample of the list which contains four dates. The first two can be easily formatted, but the last...

Hi I know about the classic problem of VBA seeing a date that was in format dd/mm/yyyy and treating it as mm/dd/yyyy instead. But I've developed 2 macros for manipulating different sets of data and I'm puzzled why one of the macros is being affected by this whilst the other macro isn't. Dim...

Hi I have a list of dates in E5 to E7, in long date format. I have a form control with an input range of E5 to E7. The cell M5 also has long date format and is the cell link for the format control. Cell M5 does not display the correct dates from the dropdown list and instead displays 1,2 or...

Hello, I have created a userform that will allow users to input multiple lines of data into a table based on a selection in a list box. The userform consists of some textboxes and a listbox (multiple selection). I have a problem with the textbox where i have to insert date. The problem is that...

Hi All The problem i have is. i have created an excel file with a userform that is a questionnaire. with in this questionnaire are several section where a date is required. once the userform is submitted a worksheet has cells filled in with the userform values. no problems here the problem...

I'm trying to count how many times the same Date is repeated in a range. This is what I have so far, and is not working. Sub counting() <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height...

Hi everyone, how are youyou doing? My problem is that I Have a colums "C" With data of the type 1.12.17 I want to change these data to the date format 01/12/17 (dd/mm/yy) I use a VBA code to replace all the dots with "/" The code looks like this: Sub ReplaceDots() Dim i, k As String i = "." k...

I have a cell that lists the date as example 11/3/17 i would like to have it list as 11/3/2017 so I can format as a date showing November 3, 2017. Can not do with 2 characters in year field. Any help greatly appreciated. Thank you

Please help. I'm having trouble getting the date format in the formula bar to match the date format in the cells of my worksheet. I have my dates formatted in my cells as m/dd/yy however the formula bar shows m/dd/yyyy. I'm trying to get the formula bar to return only the 2 digit year format I...

Hi Guys, Simple fix i hope, but this has been driving me nuts for a couple of day now. I made a CRM system to use for work, and have recently been provided with a mac laptop. when i open the crime file, it seems to have changed all of my dates to US format MMDDYYYY. i can simply change these...

I have a user form which has some textboxes on it which the user fills in information which is then entered into a spreadsheet. 2 of these textboxes are used to input dates however I have noticed an issue which I have never noticed before. When a date is entered in the format dd/mm/yyyy, if the...

I am currently using the macro illustrated below, which has been working perfectly fine for a long time. The only problem I'm currently encountering is whenever it is processing data that contains text within sentences and paragraphs, it always changes whatever the current dating format is to...