datevalue

Hi I am having trouble getting a VBA code to do the following: 2012/05/01 00:00:00 2012/05/01 00:03:00 2012/05/01 00:06:00 2012/05/01 00:15:00 2012/05/01 00:18:00 From this above to this below 2012/05/01 00:00:00 2012/05/01 00:03:00 2012/05/01 00:06:00 2012/05/01 00:09:00 2012/05/01 00:12:00...

Can anyone help me to how to convert datevalue to date? I have 41062 as datevalue, and I want to convert it to date as 02-06-2012. when I use concatenate(day(A1);"-";month(A1);"-";year(A1))-> I got it as 2-6-2012. But I want 02-06-2012. How to get that? Pl help

Hi, i have found this code here which i am trying to adjust to my needs Sub finddate() Dim cl As Range Dim lastrow As Long lastrow = Worksheets("Filter_CSM").Range("A65536").End(xlUp).Row for each cl in Range("h2:H" & lastrow).Find(What:=DateValue(<>"")) If Not cl Is Nothing Then cl.Select...

Hello all, I am sad to say I'm at wits end on this one. I automate my spreadsheets as much as possible and this one seems simple yet keeps escaping me. I have two sheets, Sheet1 has a date range and the Sheet2 has a header that needs to display the range of dates from the first sheet (ie...

I'm running a routine in MS Access that extracts dates from a text field in a financial database. Once the date is extracted, I'm using DateValue() to convert into "mm/dd/yyyy" format in order to then execute calculations on the date (days remaining, days in future, days (in years), et cetera)...