How to create date and time series with formulas

Let’s take a look.

you’re free to easily do this with Excel’s Date functions.

First, enter the start date.

Next, add a formula that begins with theDATE function.

For each argument, use the corresponding function to extract the value you need from the start date.

Now when I copy that formula down, the dates change by one month.

Notice that Excel takes care of changing the year value for me.

For the next example, I’ll follow the same process.

But this time, I’ll set the year to increase by one.

you’re able to also easily step back in time.

Just subtract values instead of adding values.

Note that all values are fully dynamic and will recalculate when you supply a new start value.

Also note that you’re free to hard code any value you like.

you might do the same thing with time values by using theTIME functionalong with theHOUR,MINUTE, andSECONDfunctions.

To generate times separated by 15 minutes, I need to add “15” to the Minute component.