Results 1 to 3 of 3

Thread: Month Day Year Formula Problem

  1. #1

    Angry Month Day Year Formula Problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am having trouble with a formula in excel 2007. If I have a cell say A1 = 9/17/11 and I want to populate C1 automatically with the same month and day but want the year to be the current year how do I do that. I have tried everything I can think of. Can someone please help.

  2. #2
    Write a simple formula in cell C1:....

    =DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

  3. #3
    Hi all,

    I want VLOOKUP function through VBA Array. Please check attached file.....
    I have tried below coding but its not working properly....


    Sub vlOoo_kup()
    Dim sh As Worksheet
    Dim rng As Range
    Dim arr
    Dim i As Integer
    Set sh = ThisWorkbook.Sheets("Singh")
    Set rng = sh.Range("A1:G21")
    arr = sh.Range("i10:i" & sh.Cells(Rows.Count, "i").End(xlUp).Row)
    For i = LBound(arr) To UBound(arr)
    Dim j As Integer
    j = sh.Cells(Rows.Count, "j").End(xlUp).Row + 1
    sh.Range("j" & j & "" & j).FormulaArray = Application.WorksheetFunction.VLookup(arr(i, 1), rng, Array(2, 3, 4, 5, 6, 7, 8, 9), 0)
    Next
    End Sub




    Thanks
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •