# Calculating dates in exce dating

In this tutorial, you will find a simple explanation of the Excel DATEDIF function and a few formula examples that demonstrate how to compare dates and calculate the difference in days, weeks, months or years.Over the past few weeks, we investigated nearly every aspect of working with dates and times in Excel.If you want to test whether the year of a certain date is a leap year, you can use a formula that uses the MONTH, YEAR, and DATE functions.In the example shown, the formula in cell C5 is: =MONTH(DATE(YEAR(B5),2,29...To generate a dynamic series of dates with a formula that increases by one month from a single start date, you can use a formula based on DAY, MONTH, YEAR, and DATE functions. If you need to convert a date to a Julian date format in Excel, you can do so by building a formula that uses the TEXT, YEAR, and DATE functions.Background "Julian date format" refers to a format where the year value...The easiest way to calculate the last day of a month is to use the EOMONTH function, which is made for this purpose.In the example shown, the formula in cell B5 is: =EOMONTH(B5,0) How this formula works The 2nd... However, the function was only introduced in Excel 2013, so is not available in earlier versions of Excel.You'll also learn how to troubleshoot, trace errors, and fix problems.Start building valuable skills with Excel formulas today. Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. If you want to calculate the number of days between two Excel dates, this can be done by simply subtracting the earlier date from the later date.For example, if the start date is stored in cell B1 and the end date is stored in cell B2, the number of days between these two dates is calculated by typing the following into any Excel cell: This method works because Excel dates are internally stored as simple integers.