Apply general format

In this video we’ll look at how to calculate due dates with the WORKDAY and WORKDAY.INTL functions. The WORKDAY function returns a date in the future or past that takes into account weekends and, optionally, holidays. You can use the WORKDAY function to calculate things like ship dates, delivery …

In this video, we’ll look at shortcuts that Excel provides for applying number formatting. First, just to recap, number formats control how a number is displayed, but they have no effect on the number’s value. You can find a list of available number formats on the home tab of the ribbon. Or you can …

In this video, we’ll look at how to generate a sequence of dates with the SEQUENCE function. The SEQUENCE function can be used to generate numeric sequences of all kinds. Since Excel dates are just numbers, SEQUENCE works well for generating dates. In this first worksheet, we have a couple cells set …

In this video, we’ll look at how to create a list of random times. In this worksheet, let’s generate 20 random times between 7:00 AM and 6:00 PM. To do this, we’ll use the RANDARRAY function. Now, RANDARRAY can generate both integers and decimal values. For Times, we want decimal values, because …

In this video, we’ll look at a couple ways to use the FILTER function to extract data between dates. In this worksheet, we have sample order data that contains a date field. Let’s set up the FILTER function to extract data between two dates. Before we begin, I want to remind you that Excel dates are …

In this video, we’ll look at how to generate a sequence of times with the SEQUENCE function. The SEQUENCE function can be used to generate numeric sequences of all kinds. Since Excel times are just numbers, SEQUENCE works well for generating times. In the first worksheet, let’s generate 9 times, one …

In this video, we’ll look at how to create a list of random dates. One of the nice things about the RANDARRAY function is that it makes it easy to generate a list of random dates. In this worksheet, let’s generate 20 random dates between May 1 and May 30, 2020. Now, to use the RANDARRAY function for …