Counting number of weeks in a period (Excel 2000 SR1)

Topic

New Reply

Is there an Excel function which will count the number of weeks in a given period?

Thanks in advance,

Christa

Reply | Quote

Replies

There does not seem to be a specific function for subtracting/adding weeks. However you could simply subtract one date from anothre and divide the answer by 7. If you want only the number of whole weeks the use =INT((A2-A1)/7), where A1 and A2 contain the date values. If you want to compute fractional values just omit the INT function.

The following is a custom function which will do the same job (whole numbers only) :

    Function WeekDiff(A As Date, B As Date)
        WeekDiff = DateDiff("ww", B, A)
    End Function

Hope that helps you

Andrew C

Reply | Quote