Results 1 to 2 of 2

Compare Dates in two excel sheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-13-2012
    Location
    germany
    MS-Off Ver
    Excel 2003
    Posts
    185

    Compare Dates in two excel sheets

    Hello Everybody,
    I want to compare the date between two excel sheets. In sheet 1 i have only the start date and end date, in sheet2 i have start date and end date (monthly basis). I want that the date of sheet 1 must be compare with the date of sheet 2.
    For the sake of example workbook is attached with this thread.

    Thanks for your help

    I also have written some vba macro, but it is not completely working,

    Sub Calculator()
            Dim Cover As Worksheet
            Set Cover = Worksheets("Sheet1")
            Cover.Activate
            
            With Cover
                iyear = Year(Range("F15")) & Month(Range("f5"))
                iyeartill = Year(Range("F16")) & Month(Range("f16"))
                imonth = Month(Range("f15"))
            End With
            
            With Sheets("sheet2").Activate
                For counter = iyear To iyeartill Step imonth
                 counter.Cells(69, 1) = "aa"
                Exit For
                Next counter
            End With
        
        End Sub
    Attached Files Attached Files
    Last edited by kate.middleton1; 01-16-2013 at 01:33 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1