Transform dates to financial half year in Google Sheets with SEMIANNUAL

Data GenerationCyrus Radfar
Jul 7

The SEMIANNUAL function is an essential tool for pivoting and grouping data by half year.

Function Signature

=SEMIANNUAL(input, format, delimiter)

Argument Definitions

[range of dates] input; required - date or range of dates to convert. If string or number is passed, the function attempts to convert to a date.

[number] format - how to generate combinations

  • 0 - S1'YY or S2'YY [default]
  • 1 - S1 or S2
  • 2 - 1 or 2 for first-half and second-half of the year
  • 3 - yyyy.S1 or yyyy.S2

[string] delimiter - also known as the separator for items in a given combination

Use the Cheat

How to Add a Cheat to a Google Sheet

Click the Code Box to Copy

Cheat copied to clipboard ✂️👍
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

We've built an interactive tutorial in Google Sheets where it's easy to see how the function works. You can read the definition, edit examples, and do some practice examples to verify that you understand how to use the function.

Copy TutorialView TutorialDownload AppScript Code
Convert a range of dates to financial half-year in four different output formats.
Cyrus RadfarCyrus Radfar

Cyrus is the friendly full-stack founder of spread_cheats. He's a work optimization fanatic.

He's also working on other projects through V1.

Related Cheats