Search:

Type: Posts; User: footoo; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Re: Text & General Format to Data Format all the data - code/VBA required

    Maybe this : =IF(ISNUMBER(A3),A3,DATEVALUE(A3))
  2. Re: Text & General Format to Data Format all the data - code/VBA required

    This is not like the data you posted.
    For example :
    24-9-2019 (is it DD-M-YYYY or D-M-YYYY?)
    4/5/2019 (is it D/M/YYYY or M/D/YYYY?)
    4/17/2019 (is it M/DD/YYYY or M/D/YYYY?)
    Are these examples...
  3. Re: Text & General Format to Data Format all the data - code/VBA required

    Need to know whether each cell is date or text, and the format of each cell (e.g. d/m/y or m/d/y).
  4. Re: Text & General Format to Data Format all the data - code/VBA required

    There does not appear to be any consistency in the content and formatting of column A.
    It seems that it contains a mixture of dates and numbers, and also a mixture of d/m, m/d, dd/mm, mm/dd, etc....
  5. Re: Text & General Format to Data Format all the data - code/VBA required

    If you have a mixture of dates and text in column A :

    =IF(ISNUMBER(A3),A3,DATE(RIGHT(A3,4),MID(A3,4,2),LEFT(A3,2)))
  6. Re: Text & General Format to Data Format all the data - code/VBA required

    Is column A formatted as text?
  7. Re: Text & General Format to Data Format all the data - code/VBA required

    =date(right(a3,4),mid(a3,4,2),left(a3,2))
  8. Thread: Date difficulty

    by footoo
    Replies
    10
    Views
    338

    Re: Date difficulty

    Dim name$, date2 As Date
    name = "Dev CB Sep 2019.xlsx"
    date2 = WorksheetFunction.EoMonth(DateValue("1/" & Mid(name, 8, 3) & "/" & Mid(name, 12, 4)), 0)
  9. Thread: Date difficulty

    by footoo
    Replies
    10
    Views
    338

    Re: Date difficulty

    Forget that - I think you can.
  10. Thread: Date difficulty

    by footoo
    Replies
    10
    Views
    338

    Re: Date difficulty

    I presume that is not your actual code because you can't use Month and Year as names of variables.

    You did not post what Name looks like (as requested by Special-K99 and dmt32).
    I'm guessing it...
  11. Thread: IF formula

    by footoo
    Replies
    3
    Views
    124

    Re: Need some help with what I thought was a basic IF formula

    =if(az2<$ax$7,"",ba2/az2*100)
  12. Re: Macro execution via the RIBBON has stopped.

    Try re-assigning the macro to the button.
  13. Replies
    3
    Views
    72

    Re: identify distinct names in filtered list

    https://www.google.com/search?q=excel+countif+visible+rows+only&rlz=1C1CHZL_enHK747HK747&oq=excel+countif+visible&aqs=chrome.2.69i57j0l5.29711j0j8&sourceid=chrome&ie=UTF-8
  14. Replies
    2
    Views
    148

    Re: VBA - auto login to website

    Sub FUNC_LOGIN_KRONOS()
    Dim appIE As Object: Set appIE = CreateObject("InternetExplorer.Application")
    With appIE
    .navigate "https://kronos-emea.dhl.com/wfc/logon/"
    Do While .Busy Or...
  15. Re: Excel 2016, formatting a cell with just a year

    Put in the first cell and fill down:

    =TEXT(TODAY(),"yyyy")+ROW(A1)-1
  16. Replies
    13
    Views
    394

    Re: proper syntax for With Rng/Evaluate?

    Doesn't post #5 do what you want?
  17. Replies
    13
    Views
    394

    Re: proper syntax for With Rng/Evaluate?

    Dim f$: f = "36, "
    Dim rng As Range: Set rng = [A1:A8]
    rng = Application.Evaluate("concatenate(" & f & """, ""," & rng.Address & ")")
  18. Re: Save to new worksheet and rename sheet to tomorrows/next working days date as ddmmyyyy

    https://www.mrexcel.com/forum/excel-questions/1029649-vba-code-next-business-day.html
  19. Replies
    1
    Views
    83

    Re: Holiday/annual leave tracker

    Maybe use a Time Sheet template.
  20. Re: VBA Code - Obtain variable row numbers; use in formula

    https://www.mrexcel.com/forum/excel-questions/1108887-hopefully-easy-sum-macro.html
  21. Thread: Percentage

    by footoo
    Replies
    4
    Views
    104

    Re: Percentage

    One way to get the correct quotation marks is via the macro recorder.
  22. Thread: Percentage

    by footoo
    Replies
    4
    Views
    104

    Re: Percentage

    Range("D2:D" & lr).Formula = "=C2/sum(C$2:C" & lr & ")"
  23. Re: Find next empty row and select Columns A to D

    If you mean the row after the last row with data :
  24. Re: Searching for information and then returning that info.

    Or :

    =IFERROR(MID(B2,SEARCH(10000,B2),10),"")
  25. Re: Searching for information and then returning that info.

    =if(mid(b2,2,5)="10000",mid(b2,2,10),"")
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4