﻿ Get Digital Help - Excel formulas, array formulas, vba, charts, pivot tables, templates and much more. - Part 2

## Calendar – monthly view

### 10 Responses to “Calendar – monthly view”

1. Diana says:

Excellent, excellent job Mr. Oscar !!!

• Oscar says:

Diana,

thank you!

2. Ray says:

Thankyou Oscar,

I am very impressed with your Excel examples. The one that tops it all for me was your detailed Pivot Table - a masterclass...

Regards,

Ray

• Oscar says:

Thank you, Ray.
Happy you like it.

3. Hung says:

• Oscar says:

Hung,

You are right, thanks for telling me.
My blog (WordPress) has changed the name of the workbook when I uploaded the file, the hyperlink function uses another workbook name and that won't work.
Anyway, I have uploaded a new workbook and this time it seems to work.

4. Hung says:

• Oscar says:

Monthly formula:
=IF(DAY(TODAY())>3, DATE(YEAR(TODAY()), MONTH(TODAY())+1, 3)+11/24, DATE(YEAR(TODAY()), MONTH(TODAY()), 3)+11/24)
Change the bolded numbers above to select a day in a month. The example above uses the 3rd in every month. 11/24 is 11 AM. A day has 24 hours.

Weekly formula:
=TODAY()+IF(WEEKDAY(TODAY())< =3, 3-WEEKDAY(TODAY()), (10-WEEKDAY(TODAY())))+15/24

Change number 3 above to select a weekday, 1 is Sunday, 2 is Monday and so on. 15/24 is 3 pm.

The daily formula is self explanatory.

To use a recurring event, go to sheet schedule and select a cell in column "Day and Time" on an event you want to recur. Change the value to the desired formula.

5. Hung says:

wow, I got it :) thanks a lot

one small thing need to change in macro Add Event: row 5 to row 6

Worksheets("Schedule").Range("B" & Lrow) = ActiveSheet.Range("N5")
Worksheets("Schedule").Range("C" & Lrow) = ActiveSheet.Range("M5")
ActiveSheet.Range("M5:N5") = ""

• Oscar says:

Hung,

## Round-robin tournament

### One Response to “Round-robin tournament”

1. Guy says:

Oscar
Thank you for this work. This is exactly what I need for a small / local table football league we have just started. Thank you very much.
Guy

## List permutations with repetition and how many to choose from

### 2 Responses to “List permutations with repetition and how many to choose from”

1. jimmy munisi says:

I have 17 games to bet, and am suppose to choose win, loose and draw.
How can I create a table with 17,matches with win,lose and draw? How many table will appear?

• Oscar says:

jimmy munisi,

The outcome is either win, lose or draw, three possibilities.
There are 17 games. 3^17 = 129 140 163 permutations.
If you want to list all permutations in a workbook, each sheet has 1 048 576 rows.
129 140 163 / 1 048 576 = 123.1 sheets
You need 124 worksheets in a workbook to list all permutations.