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
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.
We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.
This post is designated as a reviewer for Excel trainings I conduct.
Feel free to share with anyone. 😉
Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva
Posted Using LeoFinance Alpha
Congratulations @excelsheets! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s)
Your next target is to reach 1750 upvotes.
You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPCheck out our last posts:
Support the HiveBuzz project. Vote for our proposal!