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
Bookmarks