Excel: Difference between revisions

Revision as of 13:07, 8 September 2026

Wiki Pages

‎

cells(row, column)

This will format as follows:

If one day
Event (TYPE) - City (dd mmmm yyyy)
If range in same month:
Event (TYPE) - City (dd - dd mmmm yyyy)
If range is over different months in same year:
Event (TYPE) - City (dd mmm - dd mmmm yyyy)
If Event spans over more than one year:
Event (TYPE) - City (dd mmm yyyy - dd mmmm yyyy)

‎

@@ Line 1: / Line 1: @@
-==== VBA highlighting test ====
+Wiki Pages
-<syntaxhighlight lang="vba">
+== Excel ==
-Sub HelloWorld()
+__TOC__
-    Dim message
+‎<syntaxhighlight lang="VBScript">cells(row, column)</syntaxhighlight>
-    message = "Hello from VBA!" ' comment
-    MsgBox message
-End Sub
+== Formulas, etc ==
-</syntaxhighlight>
+=== Format Date Range Output ===
+* A2: The name of the event
+* C2: Start Date
+* D2: End Date
+* E2: city
+* TYPE is the kind of event
+This will format as follows:
+* If one day
+*: <code>Event (TYPE) - City (dd mmmm yyyy)</code>
+* If range in same month:
+*: <code>Event (TYPE) - City (dd - dd mmmm yyyy)</code>
+* If range is over different months in same year:
+*: <code>Event (TYPE) - City (dd mmm - dd mmmm yyyy)</code>
+* If Event spans over more than one year:
+*: <code>Event (TYPE) - City (dd mmm yyyy - dd mmmm yyyy)</code>
+‎