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

DATEFRAC()

Related functions

This site uses cookies to store information on your computer. More info...