Our Day Calculator tool can quickly give you the answer. To use it, follow these simple steps:
Enter the number of days:
Today's date is:
The date after the entered days will be:
Enter the number of business days:
The date after the entered business days will be: ()
To calculate the number of days between two dates, you need to subtract the start date from the end date. If this crosses several years, you should calculate the number of full years. For the period left over, work out the number of months.
=DAYS (end_date, start_date)
The function requires two arguments: Start_date and End_date. They are the two dates between which we wish to calculate the number of days.
Step 1: Find the average number of days in a month. Total number of days in a non-leap year. Number of months in a year.
Step 2: Use the formula to find the number of months from the number of days. Number of months = Given number of days Average number of days in a month. Example: Convert days into months.
In cell C1, type =A1+30, and then press RETURN . This formula adds 30 days to the date in cell A1.