Three month calendar on one sheet

Three month calendar on one sheet

Post by aHVtYmVyYW » Wed, 26 Jan 2005 10:53:03


How can I put a three month calendar on one page - like March, April, May on
top of each other on one sheet?
 
 
 

1. Calendar change month from multiple sheets to one sheet, Excel 2000 & 2003

2. How to line up first month, second month, third month etc.

We would like to analyse some sales transactions and check a theory of
monthly growth. ie the third month growth of a customer is 1.5 the
original month.

We have a basic Sales Transaction table with:

The following fields:

TranDate, Client, State, Amt, SalesType
10-mar-2003, ABC, CA, 1000, Hardware
10-mar-2003, ABC, CA, 800, Software
1-apr-2003, ABC, CA, 2000, Hardware
12-apr-2003, ABC, CA, 1000, Software
1-may-2003, ABC, CA, 3000, Hardware
11-jun-2003, XYZ, CA, 100, Hardware
11-jun-2003, XYZ, CA, 100, Software
12-jul-2003, XYZ, CA, 300, Hardware

I have determined that the first time the client was billed was:

SELECT Client, DATEADD(DAY, 1-DAY(min(TranDate)), min(TranDate)) As
FirstBilled
From Sales

What we would like to do now is group the billings by the first,
second, third months etc ...

Client, FirstBilled, SalesType, Month#, Amt
ABC 1-mar-2003 Hardware 1 1000
ABC 1-mar-2003 Software 1 800
ABC 1-mar-2003 Hardware 2 2000
ABC 1-mar-2003 Software 2 1000
XYZ 1-jun-2003 Hardware 1 100
XYZ 1-jun-2003 Software 1 100
XYZ 1-jun-2003 Hardware 2 300


The question therefore is how can you create an incremental count of
the month based on the FirstBilled date ?

Thank you

Uri Teitler
Business Systems Manager
SecureData Group Pty

3. Outlook Calendar recurring "First and Third Wednesdays of the month"

4. First/Last Day of Month (current and previous three months)

5. Outlook Calendar One-Month pring page, should include +1 month , .

6. Use One Month on a 12 Month Calendar

7. One computer, three users, one calendar

8. View calendar in three views, days, months, and tasks at once.

9. How do I make a two or three month rolling calendar in Outlook?

10. How do I set up a calendar with three months per page

11. Three-month planning calendar I can write on

12. Calendar Control (Three Months)

13. Writing button actions foe each day in a three month calendar

14. How do you display three months on the Outlook calendar?

15. Calendar - Recurring club meet on "third wednesday of each month"