SOLVED

Sequential dates using a starting date in Cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2674428%22%20slang%3D%22en-US%22%3ESequential%20dates%20using%20a%20starting%20date%20in%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2674428%22%20slang%3D%22en-US%22%3E%3CP%3Eusing%20Windows%2010%2C%20Excel%20for%20Microsoft%20365%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20spreadsheet%20for%20users%2C%20I%20need%20the%20spreadsheet%20to%20update%20the%20current%20date%20in%20Cell%20I3%2C%20i%20have%20used%20formula%20%3DTODAY()%2C%20I%20then%20need%20the%20excel%20document%20to%20fill%20the%20adjacent%20columns%20with%20the%20current%20date%20%2B1%2C%20%2B2%20%2B3%20etc%2C%20however%20I%20can%20not%20drag%20this%20across.%20Is%20there%20a%20way%20to%20get%20a%20spreadsheet%20to%20open%20with%20the%20current%20date%2C%20then%20auto%20fills%20the%20columns%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI3%20%3DTODAY()%2023%2F8%2F21%3C%2FP%3E%3CP%3EJ3%20%3DTODAY()%2B1%2024%2F8%2F21%3C%2FP%3E%3CP%3EK3%3D%20TODAY()%2B2%2025%2F8%2F21%3C%2FP%3E%3CP%3EL3%20%3D%20TODAY()%2B3%2026%2F8%2F21%3C%2FP%3E%3CP%3EM3%20%3D%20TODAY()%2B4%2027%2F8%2F21%26nbsp%3B%20%26nbsp%3Betc%20etc%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2674428%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2674655%22%20slang%3D%22en-US%22%3ERe%3A%20Sequential%20dates%20using%20a%20starting%20date%20in%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2674655%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1134935%22%20target%3D%22_blank%22%3E%40elizabeth1604%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20I3%3A%20%3DTODAY()%3C%2FP%3E%0A%3CP%3EIn%20J3%3A%20%3DI3%2B1%3C%2FP%3E%0A%3CP%3ESelect%20J3%2C%20then%20fill%20or%20copy%20to%20the%20right.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0703.png%22%20style%3D%22width%3A%20718px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F305006iBA52488B35E74DEC%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0703.png%22%20alt%3D%22S0703.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2674796%22%20slang%3D%22en-US%22%3ERe%3A%20Sequential%20dates%20using%20a%20starting%20date%20in%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2674796%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1134935%22%20target%3D%22_blank%22%3E%40elizabeth1604%3C%2FA%3E%26nbsp%3BAs%20a%20variant%20in%20case%20%3CSTRONG%3Eall%3C%2FSTRONG%3E%20you%20users'%20Excel%20versions%2C%20support%20dynamic%20array%20functions.%20In%20the%20example%20below%2C%20the%20SEQUENCE%20function%20produces%20an%20array%20of%201%20row%20by%2025%20columns%2C%20starting%20at%20TODAY()%20and%20incrementing%20by%201.%20Change%20the%20number%2025%20to%20you%20own%20needs%2Fliking.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-08-23%20at%2011.49.50.png%22%20style%3D%22width%3A%20413px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F305008i9AC9579B3EF86494%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-23%20at%2011.49.50.png%22%20alt%3D%22Screenshot%202021-08-23%20at%2011.49.50.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 the excel document to fill the adjacent columns with the current date +1, +2 +3 etc, however I can not drag this across. Is there a way to get a spreadsheet to open with the current date, then auto fills the columns?

 

I3 =TODAY() 23/8/21

J3 =TODAY()+1 24/8/21

K3= TODAY()+2 25/8/21

L3 = TODAY()+3 26/8/21

M3 = TODAY()+4 27/8/21   etc etc

3 Replies
best response confirmed by elizabeth1604 (New Contributor)
Solution

@elizabeth1604 

In I3: =TODAY()

In J3: =I3+1

Select J3, then fill or copy to the right.

 

S0703.png

@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.

Screenshot 2021-08-23 at 11.49.50.png

@Hans Vogelaar Thank you so much! Was clearly over thinking this. Appreciate the response.