What is your horoscope sign?

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.

Date and time functions

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 …