date format

  1. A

    Dates: Change format of start date and end date to a range (e.g., Mar 22-Apr 1 2017)

    Each week I have a spreadsheet in which column A has the start date and column B has the end date of an event, unless it is a one-day event in which case column B is either blank or has the same date as column A. I needed to create a new text column that contains the date reformatted into one of...
  2. H

    Userform Date always reverts to American 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...
  3. T

    IfDate then return day of week

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

    Index / Match on possible blank Date fields

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

    Splitting date from number string

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

    Problem with Userform 'Calendar to textbook' Date Format

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

    Registry Save and Get Problem

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

    Slashes suddenly missing from default dates after upgrade to Windows 10

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

    VBA for changing Date format

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

    VBA CODE for converting text to a DATE :-?

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

    Tool with users using UK and Dutch date format settings

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

    Formatting Date fields in csv files exported from Excel

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

    INDEX MATCH with my input dates vs dates from data logger

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

    Pivot Table Slicer - How to change date format

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

    Conditional formatting based on date doesn't clear when date is erased

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

    How to format my dates in the PowerPivot's dCalendar table ?

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

    Format date for group by function

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

    Need to identify which rows contain a date in format Jan-59

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

    Date Format Changing when VBA opens a file

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

    converting string in dd/mm/yyyy format to dat in mm/dd/yyyy format

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top