Forum Discussion

Copper Contributor

Aug 23, 2021

Solved

Sequential dates using a starting date in Cell

using Windows 10, Excel for Microsoft 365 I am trying to create a spreadsheet for users, I need the spreadsheet to update the current date in Cell I3, i have used formula =TODAY(), I then need th...

excel

Formulas and Functions

office 365

HansVogelaar
Aug 23, 2021
elizabeth1604

In I3: =TODAY()

In J3: =I3+1

Select J3, then fill or copy to the right.

Riny_van_Eekelen

Platinum Contributor

Aug 23, 2021

elizabeth1604 As a variant in case all you users' Excel versions, support dynamic array functions. In the example below, the SEQUENCE function produces an array of 1 row by 25 columns, starting at TODAY() and incrementing by 1. Change the number 25 to you own needs/liking.