1. B

    Date Formats

    Hi, We have a spreadsheet that is being used by users in USA where standard date format is "mm/dd/yyyy" and also in Australia where it is "dd/mm/yyyy". When we first open the spreadsheet before any macros are run the cell with the date in it is "Custom" format "dd/mm/yyyy". The code below...
  2. N

    Find Most Recent Date corresponding to Unique ID from Multiple Workbooks

    I have three workbooks one we will call, ‘Clients’ and the other two ‘Visits’ pertaining to visits to clients for the second half of 2017 and the first half of 2018. Each visit also has a corresponding job number. Within the Clients workbook I wish to: • populate Column O in Clients...
  3. J

    Convert date dd.mmm.yyyy to dd/mm/yyyy

    Hi, I currently have dates in Cell D1 as text as 02.Apr.2017 I need to convert them to DD/MM/YYYY. Is this possible please?
  4. T

    Converting Dates

    Hello Ladies and Gentlemen, I have a column of dates, that I want in UK date format (DD/MM/YYYY) Occasionally, the data I receive the dates are muddled up, some are in DD/M/YYYY and some are in MM/DD/YYYY The ones with a star are incorrect, and come in 'General' format...
  5. M

    Convert DD/MM/YYYY to MMM/DD

    MS Excel 2007. Column B contains dates in DD/MM/YYYY format. I need to convert the dates into MMM DD format. Year not required. Request formula. Example: 13-02-1952 to show Feb 13.
  6. P

    Scroll down to today's date

    Hi, I'm using the following script from another thread to try to have my worksheet (sheet1) scroll down to the row containing today's date on opening. Private Sub Workbook_Open() Worksheets(“Sheet1”).Select x = Format(Date, "dd/mm/yyyy") On Error Resume Next...
  7. S

    Macro to Store Date as Text

    Hi, I need to store the Excel DATE in selected RANGE as TEXT format. (dd/mm/yyyy). It means the date is displayed in dd/mm/yyyy format. But it is stored as text. Thanks in advance. - B.Srinivasa Rao
  8. H

    Macro to convert dates to dd/mm/yyyy

    I have imported data that appears as yyyy/dmm/dd for eg 2017/10/31 in Col L on sheet Sales Data I would like a macro to convert these to format dd/mm/yyyy for eg 31/10/2017 Your assistance is most appreciated
  9. N

    Date format remains when paste values?

    Hi there, I have a VLOOKUP formula that pulls through a date (dd/mm/yyyy) but the format converts the appearance to dd.mm.yyyy. I notice that when i copy and paste values, the dd.mm.yyyy value is present, but it remains as dd/mm/yyyy in the formula bar! How do i keep this as dd.mm.yyyy? I...
  10. V

    Excel 2016 + Power Query + Oracle + Parameters/Variables

    Hi everybody, first of all, sorry for my english! I have this scenario: Office 2016, connecting to a Oracle Database 11g, and running this query: WITH tbl AS (SELECT c.codchamado AS chamado, c.strtitulo AS titulo, t.strtipo AS...
  11. A

    Convert raw input from yyyy/mm/dd to dd/mm/yyyy, not just format

    Hi, I really struggle with manipulating date formats and date input fields sometimes. I've got dates entered as yyyy/mm/dd on a few hundred rows. It's easy to change the format to dd/mm/yyyy but the problem is that the raw input is still yyyy/mm/dd. So it appears excel is getting confused by...
  12. M

    Find and Replace Macro

    Hi all I have a column that will have a date in multiple cells and every day the date will change. The format of the date is dd/mm/yyyy and I'm trying to create a macro that will select all of the cells and replace the date with 'dd/mm/yyyy (whatever the date is). Does anybody know the best...
  13. H

    Finding Maxium Date in Col E on sheet Dta

    I have tried to use the following formula to find the maximum date in format mmm-yyyy that is in Col E on sheert 'Data" I use formatting in Col E as dd/mm/yyyy <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF ;border: 1px solid;border-collapse: collapse...
  14. C

    VBA to add 30 days from input date

    Hello Im trying to add 30 days into the put date but it could not work. anyone to advice me? below is the syntax Private Sub Worksheet_Change(ByVal Target As Range) Dim lastrow As Long lastrow = Cells(Rows.Count, "b").End(xlUp).Row For i = 20 To lastrow If Range("b" & i).Value <> "" Then...
  15. T

    Date / Time import issue

    Hope somebody can help ? Am importing a very large Excel database to Power BI, which includes several date / time fields (dd/mm/yyyy hh:mm format) When I import to Power BI, the time element is set to 00:00 for every entry (though the dd/mm/yyyy is as expected) ! I've checked my Formatting in...
  16. G

    user form initialising with US date not UK

    I have the following code which is bring up todays date, but is shows 11/03/2017 for today instead of 03/11/2017. My code so far is shown below but i still cannot get it to display in UK format. Can anyone tell me where i am going wrong Many thanks Private Sub UserForm_Initialize() 'default...
  17. S

    VBA date doesn't match with date in workbook

    Hi all, The format of the dates that I'm using are different although I both formatted them in the same way. I copied them to a cell in my workbook and the date that is visible in the cell and the date that is visible in the inputbox above the workbook stay different. It's like super...
  18. M

    Forcing the format of multiple text boxes

    Hi All, I have a multipage userform which has multiple text boxes (7) for Date which get entered into seven different worksheets. The problem I am having is that despite my computer's regional formatting and the format of the cells, the userform is writing them in mm/dd/yyyy instead of the...
  19. O

    Force cell entry strictly to mm/dd/yyyy

    Using Excel 2007, and I want to force entry to calls in a date column to the format mm/dd/yyyy. Currently I have the cells formatted for mm/dd/yyyy and entered data validation date range between 12/31/1999 and 12/31/2060. However some users are too lazy to look up the day case start and just...
  20. M

    Calculating average time with a dd/mm/yyyy hh/mm notation

    Hey all, I'm new here and I have an Excel question which is probably very easy for you. I have row of times in the dd/mm/yyyy hh/mm notation. If I calculate the average by =average(A1;A3;A5) it all goes well but at a (for me random) date the average isn't correct any more. It probably has to...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...