Katamejmd

In this SkillForge (wwwskillforgecom) tutorial, you'll see how to subtract two dates from one another in Microsoft Excel using the DATEDIF function The DA The Excel function NETWORKDAYS() uses the start date and end date inclusively when calculating the total business days So for row 3 the end date of 3/8/17 counts as a business day as well If you'd like to adjust this, simply subtract 1 from the total Option #2 Using TODAY () function Using TODAY () function, the date formula in Excel goes like this = (TODAY ()Birthdate)/365 Normally, to calculate someone's age, you need to subtract the birth date from the current date That's the idea with the age formula above Subtract Dates In Excel Add Days Weeks Months Or Years To Date How do i subtract a date from today's date in excel