zakruti.com » IT - Software » IT, programs, coding

Google Sheets Tips: How to Calculate Days Between Dates! - TechJunkie

video description

Rating: 4.0; Vote: 1

Google Sheets Tips: How to Calculate Days Between Dates! - TechJunkie 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
Date: 2022-03-28

← Change Location on iPhone/Android with ExpressVPN! - TechJunkie

Dump Your Smartphone with These Basic Phones! - TechJunkie →

Related videos

Computing History: Exploring The TI-99/4A

• PC World

After 10yrs of Testing, This is the BEST Upscaler. Period.

• PiXimperfect

How to Speed Up Your Android Phone (Best Settings)

• Geeks Tutorial

How to Install Windows 11 Without USB Drive (Step by Step)

• Geeks Tutorial

The DRAM Cartel - Price Fixing, Anti-Consumer Collusion, & Corporate Conspiracy

• Gamers Nexus

How to Speed Up Windows 11 (Best Settings)

• Geeks Tutorial

Comments and reviews: 3

Corey
I have tried every formula from this video and others and no matter how I do it the end result is the same. The sheet will subtract every number in the date format. Again I have done exactually what is shown here. What gives? Is there some kind of setting I need to turn off or on?? I've read through the documentation for MINUS, and DATEDIF with no effect as to either method of subtracting only the dates.
reply

Gus
Hello, brother.
Thanks for the vid.
Do you know by any chance how to get an average amount of days following a specific range?
I've tried
=Average(B2:B200, C2:C200) -
=DAYS(B2:B200, C2:C200) -
=DATEDIF(B2:B200, C2:C200 -d-) -
=MINUS(B2:B200, C2:C200)
No clue how to sort this one out.
Would appreciate it if you could help. haha
Cheers
reply

Bhagya
I just add DATEDIF months formula and date formula. So I have 4 months and 10 days normally. But when these use months are correct and dated are not shows properly. It shows 130 days.
reply

Add a review, comment