8 Important Date Functions in Google Sheets

Опубликовано: 29 Сентябрь 2024
на канале: digitidea

251

8 Important Date functions in Google Sheets
In this video you will learn 8 important date functions and how to use them in Google sheets. These date functions can be used to find days between two dates or to extract year, month or day from a date entry and other similar things. These functions are following:
1.MINUS finds the number of days between two dates
2. DATEIF finds the number of whole days or months between two dates
3.NETWORKDAYS can be used to find the working days between two dates in Google sheets
4. WEEKDAY
5. WEEKDAY & TEXT function can be used to find the day in the form of a three letter text.
6.YEAR
7.MONTH
8.DAY

These functions are useful for nearly all disciplines because dates are used all the times in google sheets.
▶ S U P P O R T T H I S C H A N N E L A T N O E X T R A C O S T

When you click on any of the following links and buy 👌ANYTHING👌, within the next 24 hrs, I will get an affiliate commission👍 But you will NOT be paying any extra amount!!!👍

▶ My Camera: https://amzn.to/3mDF5kR
▶ My Diary for PhD Students: Digitidea Diary 1 A Guided Journal for PhD Students : https://amzn.to/3iwGaZw
▶ My Tablet which I use for Online Teaching: https://amzn.to/30xTExY
▶The Document Camera for Online Teaching: https://amzn.to/3cX8keU
▶ My Microphone https://amzn.to/30yDEvP
▶ My Webcam https://amzn.to/3lgyYme
▶ My Gimbal https://amzn.to/2KgOzoH
▶ My Amazon Influencer Page: https://www.amazon.com/shop/digitidea

▶ W A T C H M Y O T H E R Y O U T U B E V I D E O S I N P L A L I S T S (B Y T O P I C)

▶ All videos for PhD Students & Supervisors: http://bit.ly/3ceQKEJ
▶ All videos on Teaching Math Online: http://bit.ly/3tLAfFR
▶ All videos on Online Teaching: http://bit.ly/3lDZTtu
▶ All videos on Online Whiteboards: http://bit.ly/3tJVZlC
▶ All videos about EdTech Tools: http://bit.ly/2Ph21vc
▶ All videos on How to Create & Sell Online Courses: http://bit.ly/3vPPHCT
▶ All videos on Scholarship Opportunities: http://bit.ly/3tNj2fe
▶ All videos on latex document preparation system: http://bit.ly/3193TIZ
▶ All videos on Google Classroom: http://bit.ly/31677wO
▶ All videos on Google Docs: http://bit.ly/3rfuP4p
▶ All videos on Google Sheets: http://bit.ly/3r8G2nr
▶ All videos on Google Meet: http://bit.ly/3re2ueX
▶ All videos on control systems: http://bit.ly/3tQYW3Z
▶ All videos on Microsoft Word: http://bit.ly/3r79ni0
▶ All videos on Microsoft PowerPoint: http://bit.ly/3seHg1L
▶ All videos on Gmail Productivity: http://bit.ly/3cae6eC
▶ All videos on video conference software and Apps: http://bit.ly/396LRvw
▶ All videos on Google Drive: http://bit.ly/2PfjHHs
▶ All videos on Trello: http://bit.ly/3rb8cOE
▶ All videos on Scilab: http://bit.ly/3vQVh7Q
▶ All videos on Facebook: http://bit.ly/3198LOh

▶ J O I N D I G I T I D E A M A I L I N G L I S T A N D G E T F R E E B I E S (PDFs, Templates, Codes, Guides, etc).

https://digitidea.ck.page/16b4752df0

▶ J O I N M Y C H A N N E L M E M B E R S H I P F O R E X T R A P E R K S
http://bit.ly/3vKRby6

Watch the following video for Details before you join, in particular if you are a small youtuber!, my behind the scene videos and shout out might help you grow your channel:
https://bit.ly/3vRBbdP

#datefunctionsgooglesheets #googlesheets #googlesheetstutorial