Day Vs Days functions in Excel

Tips-&-Tricks Apr 01, 2019

Day Function

Function Day is used to extract day from a date.

Syntax for Day is -


Parameters -

Serial_number - Serial number indicates any specific date. In Serial_number, you can type a date directly or a reference that contain date as value.


Result is 25

Days Function-

Function Days is used to calculates days between 2 dates.

Syntax -

=days(Start_date, End_Date)

Parameters -

Start_date - As the name, Here we insert the date from which we start counting days.

End_date - Here we insert the date up to that we count days.


Result is 5

Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.

If you want to learn Excel & VBA courses to be excel expert, connect us on:

9599408486 / 8929231250

Manoj kumar

Corporate Trainer at ExcelHour. I have devoted over 9 years to various industries for learning multiple data challenges and trained Excel and VBA courses to the corporate along with offline training.

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.