Google Sheets Tips: How to Calculate Days Between Dates!

Channel:
United States Guiding Tech
Subscribers:
208,000
Published on ● Video Link: https://www.youtube.com/watch?v=yZ1DT46h9Q8


Category:
Tutorial
Duration: 2:51
28,082 views
173

Google Sheets might not be as powerful as Excel, but it’s a fantastic option for anyone who needs basic spreadsheet tools, and it makes it easy to collaborate with any other Google user. If you’re trying to calculate the days between two dates, Sheets makes it easy with some simple formulas.

Formulas used:
=MINUS(C3, B3)
=B3-C3
=DATEDIF(B3,C3,"d") or "m" or "y"
=NETWORKDAYS(B3, C3), add holidays with additional coordinates

Check out the full guide at TechJunkie.com! https://www.techjunkie.com/calculate-days-between-dates-google-sheets/

Music:
Pyrosion - Road Trip
https://soundcloud.com/pyrosion/road-trip
Sachko - Seminal
https://soundcloud.com/sachkobeats/chillhop-instrumental-s-e-m-i-n-a-l



Other Videos By Guiding Tech


2020-02-07The BEST Movies Added to Netflix in February 2020!
2020-01-29Rakuten Rewards (Formerly Ebates) Review — Is It Still Worth It?
2020-01-09The FIVE Phones in 2020 You NEED to Look Out For!
2019-12-26How to Use Your iPhone as a Secret Spy Camera!
2019-12-19The BEST New Android Apps and Games in Winter 2019!
2019-12-06The BEST Christmas Movies on Netflix in 2019!
2019-11-27The Best Chromebooks to Buy this Holiday Season!
2019-11-08Checking Your Battery Percentage on iPhone 11!
2019-11-01The BEST Android Phones to Buy this Holiday Season!
2019-10-18Dump Your Smartphone with These Basic Phones!
2019-10-11Google Sheets Tips: How to Calculate Days Between Dates!
2019-10-07The BEST Movies on Netflix! — Fall 2019
2019-10-04Change Location on iPhone/Android with ExpressVPN!
2019-09-23How to Change Your Location on PC with ExpressVPN!
2019-09-16Our Favorite Comedies on Netflix! - Fall 2019
2019-09-13The BEST New Apps and Games on Android in Fall 2019!
2019-09-06The BEST Horror Movies on Netflix for Halloween 2019!
2019-08-29How to Use YouTube on Google Home
2019-08-27Save Money with an AFFORDABLE Phone Plan—Best Cheap Phone Plans in 2019
2019-08-20Add Music and Lyrics to Your Instagram Stories!
2019-08-12Clear Your Data from Google Chrome on Close!


Tags:
google sheets tutorial
google sheets formulas
google sheets tutorial for beginners
subtract dates google sheets
date functions
google sheets
google docs
google sheets tutorial for beginners 2019