YEAR function

  • 21 December 2021
  • 0 replies
  • 680 views

Userlevel 5
Badge +3

Description

Returns the year of the given Date.

 

Syntax

YEAR(Date)

 

Arguments

Argument Type Dimensions Description
Date

(required)

Date Any Dimensions Date to get the year from.

 

Returns

Type Dimensions
Integer Dimensions of argument Date

 

Examples

Formula Result Description

YEAR(DATE(2020, 12, 02))

2020 The date December 2nd 2020 has a year of 2020.

 

See also

Excel: YEAR

Related articles: MONTH, DAY

 

More of a hands-on learner? 

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace.  It includes examples of every formula and modifier in Pigment!

 

 


This topic has been closed for comments