Description
Used to return days between two dates. For example, if you want to calculate how many days do you have for the preparation of your next exam. This function can help you answer your question without you getting confused by 30/31 days in a month.
Remember not to confuse DAYS with DAY function in which Excel returns the number of a day in the month of a particular date.
=DAYS(end_date,start_date)
The DAYS function syntax has the following arguments:
- Start_date Required.
A date that represents the start date.
-
End_date Required.
A date that represents the start date.
Note: Avoid directly punching dates into Excel function, instead of either use DATE function or put date within inverted commas (“”) in this sequence i.e. Month/date/year. Otherwise excel will read the date as ZERO.
