Forum Discussion
Issue in Days Function
Hello there,
I am Balaji, I hope you are all doing well.
I am using Windows 10 in Dell Latitude 7480 Laptop.
I am facing an issue using the "Days" Function.
DAYS Function Explanation and Description mentioned in Excel Software:
DAYS FUNCTION
This article describes the formula syntax and usage of the DAYS function in Microsoft Excel. For information about the DAY function, see DAY Function.
Description:
Returns the number of days between two dates.
DAY function
This article describes the formula syntax and usage of the DAY function in Microsoft Excel. For information about the DAYS function, see DAYS Function.
Description:
Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.
Now, If I am using the "DAYS" Function to calculate the number of days between two dates.
Suggest me Which Function should I use to get the correct answer. I am Looking forward to your guidance.
Thank you.
DAYS counts the number of days from the start date to the end date. For example, it takes 6 days to get from March 1 to March 7. If you want to include both the start date and the end date in the count, simply add 1:
=E8-D8+1
or
=DAYS(E8, D8)+1
