It is getting time to reset the Weekly Reports for the next Fiscal Year. I need to determine the number of friday's between the third friday of June Lasty Year and the next year. Sometimes this is 52 and sometimes it is 53. I want the code to return that number as a variable so I can have my Data base up date a colume that runs Week one through Week 52 or 53.
KniteMare
This is what I did so far it seems to be correct but I am not certain.
Sub weeker()
Dim a, b, c
a = Range("DateStart").Value
b = Range("DateEnd").Value
c = Range("Weeks").Value
c = a - b
c = Format(c, "ww")
End Sub
??FeedBack??
KniteMare
This is what I did so far it seems to be correct but I am not certain.
Sub weeker()
Dim a, b, c
a = Range("DateStart").Value
b = Range("DateEnd").Value
c = Range("Weeks").Value
c = a - b
c = Format(c, "ww")
End Sub
??FeedBack??