Hi,
Query-1
i have created the week calendar for the month.
Week No Date From To
Week01 02.03.2015 05.03.2015
Week02 06.03.2015 12.03.2015
Week03 13.03.2015 19.03.2015
Week04 20.03.2015 26.03.2015
Week05 27.03.2015 31.03.2015
Invoice Date Dispatch Date Week
02.03.2015 02.03.2015 Week01
03.03.2015 06.03.2015 0
06.03.2015 07.03.2015 Week02
07.03.2015 13.03.2015 0
if dispatch covered same week value return the same.
in case dispatch covered next week value return 0.
Query-02
How to do sumif Row to column
File attached herewith.
pl help me.
Bookmarks