# SJS.FISCALYEAR

## Content

This function returns the fiscal year to which a specified date belongs.

## Syntax

`SJS.FISCALYEAR(date, [start_month])`

## Arguments

This function has the following arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *date* | A date string or a reference to a cell that contains the date for which you want to determine the fiscal year. |
| *start\_month* | [Optional] A number from 1 to 12 that specifies the first month of the fiscal year. The default value is 4, which represents a fiscal year beginning in April. |

## Remarks

* The returned fiscal year is identified by the calendar year in which the fiscal year begins.
* If *start\_month* is omitted, the fiscal year begins in April.
* A date before the specified starting month belongs to the fiscal year that began in the previous calendar year.
* A date on or after the beginning of the specified starting month belongs to the fiscal year that begins in the same calendar year.
* If *date* cannot be interpreted as a valid date, the function returns `NaN`.

## Data Types

Accepts string data or a cell reference. Returns numeric data.

## Examples

```JavaScript
activeSheet.setFormula(0, 0, '=SJS.FISCALYEAR("2025-03-31")'); // Returns 2024.

activeSheet.setFormula(1, 0, '=SJS.FISCALYEAR("2025-04-01")'); // Returns 2025.

activeSheet.setFormula(2, 0, '=SJS.FISCALYEAR("2025-06-30",7)'); // Returns 2024.
```