format as date

Hi, I've got an Excel workbook with column containing text which represents date&time as the specified format, i.e. 'dd.MM.yyyy HH:mm'. But this column is not recognized as a date&time, so I have to specify its format explicitly to be able to do sorting lines per this date correspondingly. When...

Trying to put the date (just number) into the respective cells of a monthly calendar based on what exists in cell a1, which in this case is 11/1/23. Appreciate any help Many thanks

Hello, I downlaoded a source file which the dates are erronieuns typed in as text. For example, Cell B4 has the following cell entry “Jan 7 2022” with the extra space, no comma and listed as general in format. Ultimately I am trying to change “Jan 7 2022” to “1/7/22”. I tied to use TRIM but...

Hi all, I need a bit of help with how to fix my date formats. I receive data weekly and I run VBA code that copies the data and paste values it into a master sheet. I also have an xlookup function referencing that date column, however, the date is coming is as half in one format and the other...

i have been finding it difficult to manage the date format in program developed by me and being used by many users in my department. in my program i have asked to enter the date as 14/06/2021. sometimes the entered date is seen as 14/06/2021 or 06/14/2021 or 14-06-2021 or 06-14-2021 Like for...

Hello Gurus, Trust you are doing well at this times. I just wanted to get your thoughts on how to code this. I have a workbook with two sheets: Sheet 1 Date Account Reference 12/30/2018 5000 0001 11/30/2018 4000 0001 10/30/2018 3000 0003 09/30/2018 4000 0002 08/30/2018 3000...

Hi all! I'm new to this forum and I'm not quite an expert in VBA, but I'm trying. I use this function to get the filedate time from a file: Function GetFileDateTime(R As Range) Set R = R.Cells(1, 1) GetFileDateTime = format(filedatetime(R.Value), "dd-mm-yyyy hh:nn") End Function This works...

I have this age old problem in many excel files When I open excel file, numbers gets change to date. This does not happens everyday but happens sometimes on some day, in some sheets in some rows. But whenever it happens it spoils by half day. I tried lots of solution, like changing cells...

I have a column of dates and times downloaded from a CSV file formatted as text as: 2019-10-10T08:30:47+00:00 Please could you generate a formula that converts the first part into: 10/10/19? Many thanks HT

Hey everyone! I used this formula to add spaces after my text as I am working on a file upload where each field must be a certain length (see formula below): ='Sheet2'!D5&REPT(" ",16-LEN('Sheet2'!D5)) I have the above formula pulling from a different sheet so I wondered if that was causing...

I have a variable in cell A50 in my sheet called Codes. The name of the variable is Endperdate. I want it to output in the date format as shown below, but it always just gives the Excel number for the date. No doubt I have something wrong with my code. Any help would be greatly appreciated...

Hi I have a report which exports the date and time in one cell (column A). I would like to be able to split these via a macro into two cells and then change the date value so it is recognised as a date. Currently the date is delimited by dots and not recognised by Excel. I would like the date...

I am new to vba. Trying to write code to generate copies from a template worksheet and name the copies from a range in primary worksheet. The ws tabs should be in a date format. So far I was able to generate the copies from the template and it makes the amount of copies in the range, but instead...