If you want to calculate the number of days between two dates, subtract the start date from the end date. If it crosses years, then calculate the number of full years. If it crosses months, then calculate the number of months. You can also use the =DAYS ("end_date," "start_date") function.