I would like to know if anyone knows how to calculate what 2 week period you
are in for a particular year given a date reference, for example.

I have a spreadsheet which I record my travel Times and Odometers on. I
useually add this up each 2 week (pay period) and get a sum, I would like to
be able to identify which 2 week period I am in so I can automatically sum it
up in a pivot table

Data as below

Start Date Destination KMs Month Year
DOW
15/03/2005 25 3 2005 2

I have seperated the Month, Year and Day of the week using formulas and
currently use my pivot table to sum KMs per month and year, I would love to
be able to do it per 2 week period, any help would be much appreciated.