Need to count days in Google Sheets? There are a few ways to do it, depending on what you want to find. For example, there are some methods especially for finding the number of days between dates in Google Sheets. This kind of calculation can be useful if you’re creating a schedule for your students …
There might be times when you want to know what weekday it is on a specific date in Google Sheets For example, you may want to know the weekday on your birthday, or on the first date of the next month. In such cases, you can use the Google Sheets day of week (WEEKDAY) Function. …
If you’re creating a timetable for students in Google Sheets, or just planning ahead, you may need to know when is the last Monday of the month (or any other last weekday day of the month). To calculate this, you can simply use the Google Sheets EOMONTHÂ function In this tutorial, I will show you …
Importing data from other documents into your current file doesn’t have to be hard. I’ll use this IMPORTRANGE Google Sheets function guide to show you how to do it in just a few minutes. This blog post will discuss the process in further detail below. But, essentially, IMPORTANGE in Google Sheets can be boiled down …
Prefer watching a video tutorial? View our “How to transpose Google Sheets “video here: If you’ve been working hard on a spreadsheet, what if you don’t like the structure of your data? You can flip your rows into columns using the TRANSPOSE Google Sheets formula. With step-by-step tutorials and screenshots, I’ll show you how to …
Ready take your Google Sheets skills to the next level? Want to lift your productivity without breaking a sweat?
Sign up for our free newsletter for regular spreadsheet guidance.
Enjoy our custom-made Google Sheets templates for free via email access
