Great, Thanks, the only question is how to delete the data (dots) from highlighted cells....actually each cell is refering 1 day and i wants to calculate the number of days worked by the sales man , by this way i can calculate the weekly utilization. For example to calculate the number of day worked in aug 1st week I am planing to use COUNTIF(C4:I4,"<>.") formula , this will count the blank cells which will be the number of days for me. If you can suggest a better way to do this...that will be a great great help. The final output i want the number os days woked by a sales man in a week.

Thanks
Rajesh