Look at WEEKNUM function.

"ricardomanet" wrote:

Hi
I data that were detected in several days of the year, but i want to
simplify the data by arranging them under work weeks so i can have simple
charts. any help will be appreciated. Also if a VBA code can be generated
that would be nice

Richard