Excel

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)

‎