SEMIANNUAL
Transform dates to financial half year in Google Sheets with SEMIANNUAL
Data GenerationCyrus RadfarJul 7
The SEMIANNUAL function is an essential tool for pivoting and grouping data by half year.
Function Signature
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 SheetClick the Code Box to Copy
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
