YearFrac

%3CLINGO-SUB%20id%3D%22lingo-sub-1151356%22%20slang%3D%22en-US%22%3EYearFrac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1151356%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%26nbsp%3B%20I%20would%20like%20to%20understand%20how%20the%20YeaFrac%20calculation%20(basis%201)%20is%20being%20computed.%26nbsp%3B%20When%20I%20do%20YearFrac(StartDate%2C%20EndDate%2C%201)%20manually%20I%20am%20not%20coming%20up%20the%20same%20results%20and%20therefore%20would%20liek%20to%20understand%20how%20this%20is%20being%20c%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1151356%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1151384%22%20slang%3D%22en-US%22%3ERe%3A%20YearFrac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1151384%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F545114%22%20target%3D%22_blank%22%3E%40delainasmith321%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20following%20describes%20the%20syntax%20for%20YEARFRAC()%20and%20provides%20an%20example%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fyearfrac-function-3844141e-c76d-4143-82b6-208454ddc6a8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fyearfrac-function-3844141e-c76d-4143-82b6-208454ddc6a8%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20basis%201%2C%20the%20calculation%20is%20actual%20number%20of%20days%20in%20the%20month%20divided%20by%20actual%20number%20of%20days%20in%20the%20year.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi.  I would like to understand how the YeaFrac calculation (basis 1) is being computed.  When I do YearFrac(StartDate, EndDate, 1) manually I am not coming up the same results and therefore would liek to understand how this is being c

1 Reply
Highlighted

Hello @delainasmith321,

 

The following describes the syntax for YEARFRAC() and provides an example:

https://support.office.com/en-us/article/yearfrac-function-3844141e-c76d-4143-82b6-208454ddc6a8

 

For basis 1, the calculation is actual number of days in the month divided by actual number of days in the year.