Daily Progress Report

**MdYas** · 08-21-2014, 03:12 AM

Dear Sir,

Please find enclosed and i have mention my problem in the sheet.

Thanks in Advance

**oeldere** · 08-21-2014, 03:35 AM

F2 till L2 = 0 1 2 3 4 5 6

d4=if(OR(F$2<WEEKDAY($B4)-2,F$2>WEEKDAY($C4)-2),"",$D4/(($C4-$B4)+1))

and drag across.

**MdYas** · 08-21-2014, 05:21 AM

Dear Sir,

Thanks for your quick reply, when i m putting finish quantity in F2 column i.e. 32 cu.mtr that is not correct, color not highlighting.

**oeldere** · 08-21-2014, 06:43 AM

For highlighting the cells, you can use data-validation.

I didn't enter that in my solution. (#2)

Re: Daily Progress Report