exceladdict
New Member
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 which are sold between 15th of this month to 14th of next month will be summed up for a single month.
Please help me..
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 which are sold between 15th of this month to 14th of next month will be summed up for a single month.
Please help me..