date and time format

I did search previous posts but fail to find an answer. :confused: Feb 01 2014, I was trying to obtain yahoo data, search in col(1) 360 days ago. x = DateValue(Date - 360) ' note, date =2/1/2014, x=2/6/2013 Set Cell_find = Columns(1).Find(DateValue(x)) I need the day 2/6/2013...

Hi, I'd like to know if it's possible, I'm sure it is, to format a column so that when I enter time in to one of the cells I can just enter 0805 and it is then automatically formatted to 08:05. I just want to do it to save a little time. I've looked at formatting the cells as hh:mm, but upon...

I have a spreadsheet that has time listed in hours and minutes. I need to add these times together but every now and then I get a, "Type Mismatch" error. Here is what the code looks like. code Public IndexArray(12, 3) As Double Public Lvl3Sum As Date x=3 Format(IndexArray(3, 2), "hh:mm") =...

Sometimes there are 28/29/30/31 days in a month in a year, right?! What's the simplest ways to meet the following task? 1. The Year or/and month can be change 2. Once the date is change the Week of days in different(Mon, Tue...) would also be changed correctly 3. Show correctly if there are...

Hi Guys, What I'm looking for is to have a macro which would do two things :- 1) A macro which looks at one column which contains date and time in "dd/mm/yyyy HH:MM:SS" , and irrespective of time, filters for the record corresponding to the start date and end date. 2)Since the source sheet...

Hey all, First post on here and I'm a brand new VBA user. I'm trying to pull data from Excel into the form fields of a Word document I've created. Some of the data I'm trying to pull are dates formatted as mm/dd/yyyy, but needs to be in Month Day, Year format for the document (i.e. "02/04/2013"...

Hi My Regional settings for date in my laptop is MM/DD/YYYY (American format) I've a sheet, which the cell A1 has custom format DD.MM.YYYY Now, I want to check if the date in A1 is valid or not by using a VBA code Say, in A1 it is 31.11.2012 (Not valid as November has no 31) How should I...

I have a field that I import with a date. Here is some sample data: 2012-11-05 rev. 003 2012-11-01 rev. 002 2012-11-09 rev. 009 2012-11-12 rev. 021 2012-11-20 rev. 022 2012-11-20 rev. 022 2012-11-17 rev. 005 I need to keep this field as it is and be able to report number of values that are...

Hello All, I have a cell that states "INVENTORY (8/8/12)" (Cell A15). Each day I need to update that cell with the new day. In another cell (Cell D7), I have the date written. I would like to change the date one time in the cell D7 and have cell A15 automatically say the same thing. I do not...

Deal All, I am data in txt file and i am doing import in excel to do reporting. while importing excel convert the date column by it own to the nearest value. eg i have data like this 17/07/2012 14:08:13.923 , once import done excel convert it to 17/07/2012 14:08:14. how can i retain the...