Show menu

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

Share on Facebook Share on Twitter

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