{"id":1358,"date":"2018-07-04T10:38:20","date_gmt":"2018-07-04T10:38:20","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1358"},"modified":"2023-11-03T14:43:32","modified_gmt":"2023-11-03T14:43:32","slug":"yearfrac","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/yearfrac\/","title":{"rendered":"YEARFRAC function"},"content":{"rendered":"\n
YEARFRAC function in Excel allows you to calculate the fraction of a year between two dates, making it useful for various financial and time-based calculations. It’s a straightforward way to determine the duration between two dates, which can be beneficial for understanding interest accruals, time periods, and more.<\/p>\n\n\n\n
YEARFRAC(start_date, end_date, [basis])<\/strong><\/p>\n\n\n\n Let’s see how to use the YEARFRAC function with some examples:<\/p>\n\n\n\n Example 1:<\/strong> Calculate the fraction of a year between two dates:<\/p>\n\n\n\n This formula calculates the fraction of a year between January 1, 2023, and June 30, 2023, using the default basis (US NASD 30\/360).<\/p>\n\n\n\n Example 2:<\/strong> Calculate the fraction of a year using a different day count basis:<\/p>\n\n\n\n In this example, the formula calculates the year fraction using the Actual\/Actual basis, giving you a more precise result.<\/p>\n\n\n\n Example 3:<\/strong> Calculate the year fraction between two specific dates and explain the basis:<\/p>\n\n\n\n Here, we calculate the year fraction for the entire year 2023, using the “Actual\/365 Fixed” basis, which considers the number of days in the year for the calculation.<\/p>\n\n\n\n YEARFRAC is a versatile function that helps you with a wide range of date-related calculations, including interest calculations, time duration, and more.<\/p>\n","protected":false},"excerpt":{"rendered":" YEARFRAC function in Excel allows you to calculate the fraction of a year between two dates, making it useful for various financial and…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
start_date<\/strong><\/td> The starting date of the period.<\/td><\/tr> end_date<\/strong><\/td> The ending date of the period.<\/td><\/tr> [basis]<\/strong><\/td> (Optional) An optional argument that specifies the day count basis to use. If omitted, it defaults to 0 (US NASD 30\/360). You can choose from various basis options to determine the day count convention used in the calculation. For example, 0 represents US NASD 30\/360, 1 represents Actual\/Actual, and so on.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=YEARFRAC(\"2023-01-01\", \"2023-06-30\")<\/code><\/pre>\n\n\n\n
=YEARFRAC(\"2023-01-01\", \"2023-06-30\", 1)<\/code><\/pre>\n\n\n\n
=YEARFRAC(\"2023-01-01\", \"2023-12-31\", 3)<\/code><\/pre>\n\n\n\n