Week of Month?

T

Tammy F

I need to find out the week of the month.
Data:
1/18/2004 20.00
1/25/2004 20.00
2/1/2004 40.00
2/29/2004 20.00
3/1/2004 20.00
4/4/2204 80.00
4/11/2004 20.00
4/18/2004 20.00
Here's what I want to report:

Month Week 1 Week 2 Week 3 Week 4 Week 5
Jan. 0.00 0.00 20.00 20.00
Feb. 40.00 0.00 0.00 0.00 20.00
Mar. 20.00 0.00 0.00 0.00
Apr. 80.00 20.00 20.00 0.00

How do I find out the week as per the month?
Thanks, Tammy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top