Excel FunctionsExcel DAYS Function


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. 


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.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.