DATEFRAC function

Description

DATEFRAC(date) converts date into a fractional year-number. The integer part of this number is the year, and the decimal fraction ranges from 0.0 to 0.99..., representing the dates 01 Jan to 31 Dec.

Example

DATEFRAC("07.01.2000") returns 2000.5 (date format MM.DD.YY)

Calculator

Related functions

• List of Date and time functions