Calculate day of the year in Excel with formula. Unfortunately, there is no direct function for us to calculate the specific day of a year, but you can apply the following simple formula to solve this task. 1. Enter this formula: =A2-DATE (YEAR (A2),1,0) into a blank cell, see screenshot: Tip: A2 contains the date that you want to calculate the day of the year, you can change it to your need.

To calculate a decimal number that represents the number of months between two dates, you can use the YEARFRAC function like this: = YEARFRAC ( start , end ) * 12 YEARFRAC returns fractional years between two dates, so the result is an approximate number of months between two dates, including fractional months returned as a decimal value.

You can use the INTCK function to calculate the difference between two dates in SAS. This function requires you to define the interval, the start date, and the end date. Depending on the interval, it returns you the difference in days, weeks, months, etc. INTCK(interval, start date, end date <, method>)