I'm not sure where you're getting your original data,but based on the
information you provided, you could:
- Add a "Week Number" column and use the function: =WEEKNUM(C6,2) copied down
the list. (the ",2" specifies weeks starting with Monday)-Then, use
=SUMIF($F$6:$F$36,$F$6+0,$E$6:$E$36)
=SUM
Hi experts,
Please in helping a dynamic formula to sum the value basis on Monday to
Sunday week. where the first day is dynamic of every month.
I have attached the excel file for explanation of problem . . .
please help, quick help would be much appreciate.
--
Pankaj Pandey
Bhopal
--
Are you
