Hi

I am trying to pivot source data and need the results in a weekending format. I have inserted a new column next to the date and i need a formula which puts the date into a weekending.

My date is in C2, i need all days Thursday through to Wedndesday to show as the Wednesday weekending, for exmaple Thursday August 5th 2012 through to Wednesday September 5th needs to show as week ending September 5th. Then Thursday 6th through to Wednesday 12th September will all show as weekending 12th September.

Can one formula work a whole years worth and can you help?

Thanks

Bezza