In cell C2 enter A2B2 and copy down as needed. That divides the number of days by 7 since there are 7 days in a week. Calculate number of days between dates in Excel with DATEDIF Another way to count days between dates in Excel is by using the DATEDIF function which is specially designed to work out the date difference in various units including days months and years.
Calculate number of days between dates in Excel with DATEDIF Another way to count days between dates in Excel is by using the DATEDIF function which is specially designed to work out the date difference in various units including days months and years.
In cell C2 enter A2B2 and copy down as needed. The date property support calculating with number. You can enter a negative number to subtract days from your. At last enter the numbers of years months weeks or days that you want to add for the given date.