date & time format

Hi, I have data from multiple CSV files that I want to compile into one sheet. I found a macro online for this: Sub ImportCSVsWithReference()'UpdatebyKutoolsforExcel20151214 Dim xSht As Worksheet Dim xWb As Workbook Dim xStrPath As String Dim xFileDialog As FileDialog Dim...

I've a column D (which I plan to hide later) either filled with a date or left blank. Then I want to have column E either display the date from Column D if the date is within one year or display nothing if the date is over one year old. The format I have right now in D2 is...

So for work, I have an excel spreadsheet that I use to keep track of documents I send out for specific patients I deal with. Some of the columns are dates that are always changing. I'm wondering if anyone knows a way to format the cells so that I don't have to type in the full date? For...

Hi all, I've been trying to get a string in the format of 31st Aug 17 4:12pm AEST into a usable date format. Things I've tried so far include but are not limited to the DATEVALUE function, =LEFT(O2,2) function, however not sure how to make sure when numbers go from single to double digit it...

Hi, I am creating excel database (input via Userform) where i am facing two issues. could someone help me on below: 1. I am entering data through form and it is saving in sheet2 . The data contains numbers, date, text etc. But the numbers are saving in text format which is difficult for excel...

Hello all, I'm writing a module to convert date & time provided in UTC format, into a local time zone of my choice. The code works fine in converting to the required time zone, but I want to them place a formatting over the top to indicate which time zone it relates to. I do not want to add...

Hi all, I have seen many posts about changing a date from DD/MM/YY format to YYMMDD format; however, there has been a number of solutions and i have tried to implement some but to no avail. I want to paste into a format with no "/"s, just YYMMDD and for example, if it was 12/09/17 it would...

Hi Guys, Does anyone know if you stop a macro running if it is within 48hrs of a date specified in range a1(from) a2 (To) Sheet 1. many thanks Jamie

Hi, I have some data that was imported from HOBO into a .csv file in Excel. It includes a date and time column, but about half of the dates are being read incorrectly in Excel. It is treating the month as year and day as month. For example: 2015-08-01 is being changed in Excel to 2008-01-15. I...

Hello, I am new to this forum and hope someone can help me to understand how the Networkdays result is being calculated in my project. I have created a calendar that uses the date function to store and display the day only value in a pictorial calendar. Here is the start date - April 29...

Hi guys, I have a big file with columns D & E that contains time of starting an action (D) and finishing the action (E). I need the time in a custom format, like: mmmm dd, yyyy hh:mm:ss AM/PM Records are from the last 2 years, but i'm interested in a specific month, let's say, January 2017 and...

Hi, Can anybody help me in converting this excel logic to macro or formula: Requirement- Convert Months/Years/Days/Hours ago time to Minutes., and give ranking to it. I Have excel file with colmn Time and Download count in column D and E, i want to find out average download time per minute...

As a newbe, I tried to receive the date of birth from a form in a local format: ddmmyyyy. somewhere I messed up, but couldn't find a correct solution. Can anybody tell me where I'm wrong and how to correct? Here's my code sofar: Private Sub dtpGeboorteDatum_Exit(ByVal cancel As...

Hi there, I am in need of help with a SUMIFS function I'm trying to use. I am trying to sum the total quantity of products sold in a column if it matches the SKU and date in the corresponding column. In this first image you can see the function: Sheet 1: https://postimg.org/image/xi73c6fij/...

Howdy, I am using Power Query to merge tables from several excel files into a master table. In these source tables there are two date columns A and B. Date column A contains only dates. Column B contains blanks, dates and sometimes text - always the text "Enter Date" When I import the...

Hi guys, I'm working on a "membership" database for a greyhound rescue volunteer group, to try and help them organise things a bit better (their "manual" system wasn't too flash). I've got things working (for the most part) how I want them to... just fixing minor issues as they come up, now...

I have userform text boxes with dates in them in the format "dd/mm/yyyy". I want to be able to show however only the "dd". The issue is that if I use this code: Label20 = Format(Label20, "dd") Then the actual contents of my data gets lost. Ie using the code msgbox label20 returns only the...

Hello, I've got column of dates in following format "28th September", "29th September" etc... is in text format. How can i make a common date from this format? Result should be "28/09/2016" or "28.09.2016". When I change formatting nothing is happening :( Thanks in advance,

Hi I have a SQL table with a Datetime format field in it (create_date). I have linked to this table in Access and created a query which includes a field that is the date only part of this field. I want the date only as the output which is then exported to EXCEL. It uses this formula to convert...

I am scraping data from a flight planning website that brings a date value into a cell like this: "Tue. 7/26". Currently I have the formula "=RIGHT(X42,2)" to extract the day and "=MID(X42,6,1)" to extract the month. This formula doesn't work all of the time depending on whether or not the...