SEMIANNUAL
Transform dates to financial half year in Google Sheets with SEMIANNUAL
Data Generation Cyrus RadfarJul 2
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 SheetClick the Code Box to Copy
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 Tutorial View Tutorial Download AppScript Code
