date format

I was going to ask how to do this, but I think I worked it out all by myself :-) So I thought I'd just check whether this is the most 'elegant' way of doing it? I need to filter a range of records in my "AAA Complete Forecast" column that occur between 'today' and 10 days' time. I had some...

Hello, I was just recently upgraded from Office 2010 to 2013. I had several macros in 2010 that I used regularly that are no longer working. One of the reasons has been resolved -> it was having issues with date formats or recognizing dates even when manually typing them in. This was fixed...

I receive a file with a date in the format e.g. 20111025. So this example signifies October 25th, 2011. I need the ability to work with it as a true date (in furhter downstream formulas). This is what I did : assuming that 20111025 stands in A1, I would enter following formula in B1 ...

Hi, This is my first question on the forum. Please excuse any etiquette mistakes I might have made. I am using Excel 2010 on Windows 7 and I am having an issue with data validation. My operating system is set to English (US) and returns dates in mm/dd/yyyy format. However, I am creating a...

Need help in getting sum if array to work. I need to sum the data array for all matching "stores", (Column B), and to make sure it is greater than the date constraint, (Column C). I tried ... =SUM(IF($B$9:$B$23=B4,IF($C$8:$M$8>C4,$C$9:$M$23))) CSE This works on the example I attached. My...

Hi All! I'm new to VBA so apologies if this is more straightforward than it seems. I have a spreadsheet which is used to automate some report formatting and create graphs for an end user. The end user exports the required reports from our database, pastes them into my workbook and my macro then...

I have a userForm that asks the date of birth of a client. The date has to be entered in the textBox only like this format: dd/mm/yyyy or else I don't want it to accepted (For example: this format should NOT work: mm/dd/yyyy ) I need help with the code... thanks!

I have created in Excel 2010 a worksheet using the script below. The problem is the date format. Sometimes I get the preferred date format example. However most of the time I get the wrong date format. The date data is sourced from column “B” and in this example row “6”. How can I correct the...

Hi, I have: <tbody> Date C17 = Jan FY13 Name C20 = Audi Owner E53 = </tbody> C17 is like: Jan FY13, Feb FY13, Jun FY13, Apr FY13, May FY2014 In my source I have column with other format date (Sheet2, column B): DD-MMM-YYYY (31-May-2014 or 30-Apr-2014). Now I want to use Match...

Hello Excel Geniuses! I have a some dates in a format which are not being converted into the normal date format. So i made this formula to convert it into the normal date format...

Hi Everybody. First time poster here. I'm new to prgramming in general and have only been doing VBA work for a couple of weeks. So please feel free to ask for clarification. I only ask that you use "little words" that I can understand. I am trying to set up a few lines of code that will delete...

Hi, I have in column A dates: 31/12/2014 31-11/2013 03/Mar/2014 05:11 AM 04-Jan-2013 07:45 How can I simply in column B select date, to have it one format: DD-MM-YYYY ? When I'm using function "DATE" = date(A1;A1;A1) it didn't work.

Hello all, A colleague has stumped me with this problem. A mail merge involving a UK format date from excel 07 to Word 03 selectively ignores the field codes set in the Word document. The date should be 2nd July 2013, displayed as 02/07/2013, but comes out as 07/02/2013. Now, we are not...

I am trying to figure figure out how the length of time between two dates (an online and offline date). First the facts: Windows7 & Excel2010, I have tried formatting the cells to 'Date' which does not help and I have 1000+ date ranges to calculate. The formula I found to do this is...

Hi, in csv file I have column, where are date's with diffrent format as below: 02/03/2014 00:10 1/02/2014 7:25:00 7/03/2013 8:30:00 PM I want to set up the same format for all date's. I`m doing something like: With WS LastRow = WS.Cells(WS.Rows.Count, "A").End(xlUp).Row .Range("T" &...

<tbody> 41913 41913 41913 41913 01/24/2014 01/24/2014 01/24/2014 01/19/2014 01/19/2014 01/19/2014 </tbody> Hi there, I'm importing data into Excel from an external source, in one column I have a series of dates. The problem is that Excel is importing these dates differently...

I have a VBA script to open a CSV file (output from Notes) and then process this file in a new Macro enabled workbook, ending with a nice pivot table. I just recently notcied that the number of rows I'd expect to see for, say, August 2013 is far less than it should be. I then found a number of...

Hi there, I have an Excel 2010 spreadsheet where the default number format keeps switching to the date format. I keep switching it back and it'll stay as a number format for a time, but then it'll switch back. This is also the case for any new worksheets in that one spreadsheet. This only...

Hello all, I am suffering from a highly specific problem that I havent been able to find a viable answer for through the usual search engines. I am hoping someone here can help. I am trying to autofilter a data set based on criteria that I parse from a Countifs formula. So the countif...

I formatted a cell as a date but somehow people still manage to mess it up. Is there a pop-up calendar that appears when the user clicks on a cell?