Following on from my post on the basic date functions, let’s look at some really useful functions that work with dates, namely: WEEKDAY, WORKDAY, NETWORKDAYS, EDATE and EOMONTH, plus we’ll see an example with the CHOOSE function. With these we’ll: Find out the day of the week of a particular date Work out a deadline date Work… Continue reading Google Sheets Functions – WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH
Month: November 2016
Google Sheets Functions – GOOGLETRANSLATE, DETECTLANGUAGE
Lots of people know about and have used Google Translate either on their phones or on the Google website but what they often don’t know is that there is a built-in function in Google Sheets, which will allow you to translate from one language to another, and even automatically recognise the language and translate it. So,… Continue reading Google Sheets Functions – GOOGLETRANSLATE, DETECTLANGUAGE
Google Sheets Functions – NOW, TODAY, DAY, MONTH, YEAR
In this post, we’re going to look at some of the basic date functions and in particular, how we can extract parts of a date or a time. We’ll cover: NOW, TODAY, DAY, MONTH, YEAR, HOUR, MINUTE, and SECOND. Example 1 – Getting the current date and time We can add the current date and… Continue reading Google Sheets Functions – NOW, TODAY, DAY, MONTH, YEAR
Google Forms – Quizzes
In this post we’re going to look at the quiz option in Forms. Since its release earlier this year, I’ve been using it with various classes mainly to check their progress, and it really is a simple but highly effective tool, which I recommend everyone to use. To start let’s just look at the 4… Continue reading Google Forms – Quizzes
Google Sheets Functions – UNIQUE, COUNTUNIQUE, SORT
In this post we’ll look at how we can remove duplicates from a set of data, with one simple formula using the UNIQUE function. We’ll also use the SORT function to put the unique list in order and use this in a drop down menu using DATA VALIDATION. Finally, we’ll look at counting those entries… Continue reading Google Sheets Functions – UNIQUE, COUNTUNIQUE, SORT