date format

Dear all, I have a problem with american date formats always reoccuring. I have seen other posts on this problem but none matching my particular issue. I have a userform in which my users enter data which is then added to the excel spreadsheet. Sometimes they need to amend this data so we have...

I have a file "Blank Master" that returns the file name to cell A2... We re-save the file daily as the date i.e "May 17, 2016" with the updated and relevant data. I would like Cell A1 to return the day of the week once the file is re-saved as a date. With this in A1...

I am using the following syntax to find a possible date or blank: =INDEX(Invoices!$B$2:$B$192,MATCH(E2,Invoices!$A$2:$A$192,0)) Since the column were the result is displayed should be in date format, empty finds are displayed as 1/0/1900. I know that I can use the test: IF (result = blank...

Hello, I have a spreadsheet with 1000+ dates that are listed in this format... 20150415 And I need it in this format: 04/15/2015, or with each year/month/date split into individual cells? Is there some way to separate the year, month, and day from this numerical string? I've tried formulas to...

Hello there, Can someone help me please? I'm operating on Excel 2007 and using Calendar Control 11.0. I have textbox (tbDJ1) on a userform (CaseManagementSystem) and next to it is a command button. Click on the command button and it shows a calendar on a separate userform (Calendar), click on a...

I have the following code that runs when the spreadsheet is open. I have a type mismatch on the date portion when I try to set a default date if there is no data exists in that registry entry. I am sure this must be a simple mistake, but I can't figure out what I am doing wrong. Preferably, I...

Hello! We recently upgraded from Windows 7 to Windows 10, using our old copy of MS Office 2010. I have noticed that all the spreadsheets I have suddenly had slashes missing. So 5/16/16 now reads as 5 16 16. So, I looked at the number formats, and it looks like the slash has been completely...

Is there a way to change the date format from dd/mm/yyyy to mm/dd/yyyy using VBA code?

Hi Working with Excel 2016 I'm receiving a "csv" file from a 3rd party program with dates in column "A" but it is text and I can not format it to a date in excel. I'm looking for a VBA code that will take the text values in column "A" like 16/09/2015 for 16-Sep-2015 and like 03/11/2015 for...

Dear all, I have a question about the date format in a tool I made. Some users use the Dutch format: dd-mm-jjjj uu:mm, and others the UK format dd/mm/yyyy hh:mm. For the output of this tool I transform the data to a text format =text(E6;dd/mm/jjjj uu:mm) because the upload doesn't pick up...

I've created a spreadsheet to capture data which formats a date field in yyyy-mm-dd format which is required in a database that is going to import the data via a csv file generated from the spreadsheet. When I save the spreadsheet in .csv format, I find that Excel has changed the dates to...

Hi There. This has undoubtedly been asked before but here I go. I import an Excel data sheet from a piece of data logging equipment. In one column there is date & time in the format mm/dd/yyyy hh:mm and the adjacent column contains a temperature. The date & time cells increment in 1 minute...

I have a date field in a pivot table which is sourced from a list object table all within the same workbook. The slicer date format is 11/06/15. I want to change its format to 11/06. Things I have tried so far with no effect in the slicer date format: change the format of the all dates...

One of my conditional formatting rules is giving me some grief. This might be simpler with VBA, but I'm trying to avoid using a macro-enabled sheet since the file is shared overseas, I'm new to the company, and I'm not sure how they'd feel about me modifying the sheet that much. Anyhoo... The...

Hi, Can I have my dates in the dCalendar table in "dd/mmm/yyyy" format instead of "dd/mmm/yyyy hh:mm:ss" ? When I create my dCalendar I always tempted to follow "dd/mmm/yyyy" separating times. I usually maintain a separate table for times as it gives the flexibility to run the Hour , Minute...

Hello Friends, For my report I have to group records by Month/Year. The data has date in the format of date+month+year+time; I was able to reformat to Month-Year format. But the problem is that the reformat is just a view. When I try to group based on the reformatted data Access considers...

I have in col A, hyperlinks, words in text, and dates in the format Jan-59. Not all dates equal Jan-59. I need to identify which rows in col A contain dates so I can copy and move the dates to column C as I delete dates out of col A. Thank you in advance for any replies.

Hi If I manually open a CSV file all of the dates appear in the UK format DD/MM/YYYY. When VBA opens the exact same file the way it interprets the dates is in the US format MM/DD/YYYY. So the date 09/02/2015 changes from 9th Feb to the 2nd Sep. And the 26th Feb becomes a text field. I am using...

Hi All, I am a newbie here and would like to apologize in advance if this question has already been answered before (If yes, please direct me to link as I couldn't find it via search) My problem: I get regular data that I import in excel. Column A is always date but in dd/mm/yyyy format (my...

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...