pub struct IsoWeekNumFn;Expand description
Returns the ISO 8601 week number (1 to 53) for a date serial.
§Remarks
- Weeks start on Monday and week 1 is the week containing the first Thursday of the year.
- Input serials are truncated to whole dates before evaluation.
- Serials are read using the Excel 1900 date mapping.
§Examples
title: "ISO week at year start"
formula: "=ISOWEEKNUM(45292)"
expected: 1title: "ISO week crossing year boundary"
formula: "=ISOWEEKNUM(42370)"
expected: 53related:
- WEEKNUM
- WEEKDAY
- DATE
faq:
- q: "Can early-January dates return week 52 or 53?"
a: "Yes. ISO week numbering can place dates near New Year in the prior ISO week-year."Trait Implementations§
Source§impl Debug for IsoWeekNumFn
impl Debug for IsoWeekNumFn
Source§impl Function for IsoWeekNumFn
[formualizer-docgen:schema:start]
Name: ISOWEEKNUM
Type: IsoWeekNumFn
Min args: 1
Max args: 1
Variadic: false
Signature: ISOWEEKNUM(arg1: number@scalar)
Arg schema: arg1{kinds=number,required=true,shape=scalar,by_ref=false,coercion=NumberLenientText,max=None,repeating=None,default=false}
Caps: PURE
[formualizer-docgen:schema:end]
impl Function for IsoWeekNumFn
[formualizer-docgen:schema:start] Name: ISOWEEKNUM Type: IsoWeekNumFn Min args: 1 Max args: 1 Variadic: false Signature: ISOWEEKNUM(arg1: number@scalar) Arg schema: arg1{kinds=number,required=true,shape=scalar,by_ref=false,coercion=NumberLenientText,max=None,repeating=None,default=false} Caps: PURE [formualizer-docgen:schema:end]
fn name(&self) -> &'static str
fn min_args(&self) -> usize
fn arg_schema(&self) -> &'static [ArgSchema]
Source§fn eval<'a, 'b, 'c>(
&self,
args: &'c [ArgumentHandle<'a, 'b>],
_ctx: &dyn FunctionContext<'b>,
) -> Result<CalcValue<'b>, ExcelError>
fn eval<'a, 'b, 'c>( &self, args: &'c [ArgumentHandle<'a, 'b>], _ctx: &dyn FunctionContext<'b>, ) -> Result<CalcValue<'b>, ExcelError>
The unified evaluation path. Read more
fn namespace(&self) -> &'static str
fn variadic(&self) -> bool
fn volatile(&self) -> bool
Source§fn aliases(&self) -> &'static [&'static str]
fn aliases(&self) -> &'static [&'static str]
Optional list of additional alias names (case-insensitive) that should resolve to this
function. Default: empty slice. Implementors can override to expose legacy names.
Returned slice must have ’static lifetime (typically a static array reference).
fn function_salt(&self) -> u64
Source§fn eval_reference<'a, 'b, 'c>(
&self,
_args: &'c [ArgumentHandle<'a, 'b>],
_ctx: &dyn FunctionContext<'b>,
) -> Option<Result<ReferenceType, ExcelError>>
fn eval_reference<'a, 'b, 'c>( &self, _args: &'c [ArgumentHandle<'a, 'b>], _ctx: &dyn FunctionContext<'b>, ) -> Option<Result<ReferenceType, ExcelError>>
Optional reference result path. Only called by the interpreter/engine
when the callsite expects a reference (e.g., range combinators, by-ref
argument positions, or spill sources). Read more
Source§fn dispatch<'a, 'b, 'c>(
&self,
args: &'c [ArgumentHandle<'a, 'b>],
ctx: &dyn FunctionContext<'b>,
) -> Result<CalcValue<'b>, ExcelError>
fn dispatch<'a, 'b, 'c>( &self, args: &'c [ArgumentHandle<'a, 'b>], ctx: &dyn FunctionContext<'b>, ) -> Result<CalcValue<'b>, ExcelError>
Dispatch to the unified evaluation path with automatic argument validation.
Auto Trait Implementations§
impl Freeze for IsoWeekNumFn
impl RefUnwindSafe for IsoWeekNumFn
impl Send for IsoWeekNumFn
impl Sync for IsoWeekNumFn
impl Unpin for IsoWeekNumFn
impl UnsafeUnpin for IsoWeekNumFn
impl UnwindSafe for IsoWeekNumFn
Blanket Implementations§
Source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
Source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more
Source§impl<T> IntoEither for T
impl<T> IntoEither for T
Source§fn into_either(self, into_left: bool) -> Either<Self, Self>
fn into_either(self, into_left: bool) -> Either<Self, Self>
Converts
self into a Left variant of Either<Self, Self>
if into_left is true.
Converts self into a Right variant of Either<Self, Self>
otherwise. Read moreSource§fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
Converts
self into a Left variant of Either<Self, Self>
if into_left(&self) returns true.
Converts self into a Right variant of Either<Self, Self>
otherwise. Read more