Excel: Difference between revisions
PhantomSteve (talk | contribs) start.... |
PhantomSteve (talk | contribs) start with a bit more... |
||
| Line 1: | Line 1: | ||
Wiki Pages | |||
== Excel == | == Excel == | ||
__TOC__ | __TOC__ | ||
<syntaxhighlight lang="VBScript">cells(row, column)</syntaxhighlight> | <syntaxhighlight lang="VBScript">cells(row, column)</syntaxhighlight> | ||
== Formulas, etc == | |||
=== 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 21:29, 31 August 2026
Wiki Pages
Excel
cells(row, column)
Formulas, etc
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
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)