The CURRENTPERIODSTART function returns the start date from a model's current period.
For example, you can use this function to ensure that a formula only applies to the current period in a financial year.
Syntax
CURRENTPERIODSTART()
Arguments
- CURRENTPERIODSTART doesn't take any arguments.
- This function returns a date result.
Syntax example
CURRENTPERIODSTART()
In this example, the formula returns the start date from the current period.
Additional information
- The function returns a blank value if no Current Period is specified in the Model Calendar.
- When the Current Period is changed, any cells with the
CURRENTPERIODSTART()formula will also be updated to reflect the new value.
Examples
Example 1: Identify the current month
Example 2: Identify the current week
Example 3: Apply a promotional uplift only in the current month
Example 4: Calculate current month revenue variance
