Calculate difference between two dates
May 26, 2021
1. =DATEDIF(StartDate, EndDate, Interval)
a. Interval can be Y, M,D,YM,MD AND YD)
b. Examples:
i. =DATEDIF(“11/6/20”,”11/26/20”,”D) = 20 Days
ii. =DATEDIF(“11/6/20”,”12/25/20",”D”) = 49 Days
Sign up to discover human stories that deepen your understanding of the world.
Free
Distraction-free reading. No ads.
Organize your knowledge with lists and highlights.
Tell your story. Find your audience.
Membership
Read member-only stories
Support writers you read most
Earn money for your writing
Listen to audio narrations
Read offline with the Medium app
Written by Beanstalk CFO Group
Our firm, Beanstalk CFO Group, delivers financial management & advice to small business owners.
