DAYS function

DAYS Function

Function Type:

Date and Time


Description:

DAYS function in Excel or Google Sheets is used to compute the number of days between 2 dates.
This is equivalent to subtracting an End Date and a Start Date.


Function Structure: 

=DAYS(end_date,start_date)


Arguments 

end_date – this is the date or serial number representing a the end date

start_date – this is the date or serial number representing a the start date


Examples 

DAYS function examples

So in the example above, there are 233 days before christmas.

formula can be written as =DAYS(C3,B3) or =C3-B3


Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

Get Instant Expert Help on Fiverr

Get Instant Expert Help in PeoplePerHour

We can also accept LEOHIVEHBD tokens as payment if we transact directly here in HIVE network.

or you can help me through https://www.buymeacoffee.com/cashheaven šŸ˜‰


Back to Learn Excel->

Published by Cash Heaven

Excel Expert and Financial Analyst Excel / Google Sheets / Financial Modelling, Valuation and Analysis Effective communicator / High quality / Affordable / Reliable / Quick Turnover I've successfully completed over 200 financial modelling, valuation and analysis projects with start-up stage and corporate companies over the past 4 years. I love to solve problems, have an eye for design, and have built business excel templates. I fix Excel formulas in 10 minutes.

One thought on “DAYS function

Leave a Reply

Discover more from Cash Heaven

Subscribe now to keep reading and get access to the full archive.

Continue reading