Here’s a fun topic! At the same time, this is a good opportunity to practice working with the LOOKUP function. Although, these days, people are talking much more about the XLOOKUP function I don’t see why, in this situation, we wouldn’t use its “older cousin”. Task: determine the zodiac sign of the person whose birthday is on the given date. This is achieved by searching the table that contains the range of dates that determine zodiac signs.
The FILTER function can also contain multiple criteria, and if we want to consider them all at the same time, they must be in parentheses, separated by an asterisk. This is a convenient way to filter sales results by date, and set the criterion by changing the year and month values from the drop-down list we have created by using Data Validation option.
When the reports contain dates and/or times, it is useful to know how to use the date and time functions. These functions allow us first to retrieve the system date and/or time and to display it within the cell. Then, by using them, we can distinguish a date/time unit (day, month, year, hour, minute, second, etc.) and use them to calculate the time or date in the future. For example, a date that comes in 5 days …