hi,
i want to know the formula for displaying the months with year from the dates.I had a worksheet with columns:-
A: Products A,B,C & So on....
B: Date Sold
C: Quantity
D: Amount.
Criteria:I want to show the summary of the products sold monthly,like,
For product A; All the products A...