Excel: Difference between revisions

@@ Line 1: / Line 1: @@
-Wiki Pages
+== Create a new article ==
-== Excel ==
+* [[PhantomWiki:Create an Excel article|Create an Excel VBA article]]
-__TOC__
+* [[PhantomWiki:Create an Excel formula article|Create an Excel formula article]]
-‎<syntaxhighlight lang="VBScript">cells(row, column)</syntaxhighlight>
+== Browse Excel articles ==
-== Formulas, etc ==
+* [[:Category:Excel VBA|Excel VBA macros]]
+* [[:Category:Excel formulas|Excel formulas]]
-=== 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>
-‎

Revision as of 14:42, 15 September 2026