Transform dates to financial half year in Google Sheets with SEMIANNUALData GenerationCyrus Radfar
The SEMIANNUAL function is an essential tool for pivoting and grouping data by half year.
[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 CheatHow to Add a Cheat to a Google Sheet
Click the Code Box to Copy