SOLVED

date populate based on what the user enters

%3CLINGO-SUB%20id%3D%22lingo-sub-2332496%22%20slang%3D%22en-US%22%3Edate%20populate%20based%20on%20what%20the%20user%20enters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2332496%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20trying%20to%20have%20the%20date%20populate%20based%20on%20what%20the%20user%20enters%20(see%20below).%20I%20used%20the%20formula%26nbsp%3B%3DIF(ROW(A1)%26gt%3B%3D%24B%242%2C%22%22%2CDAYS(%24A%244%2CROW(A1)))%20but%20as%20you%20can%20see%20it%20includes%20dates%20past%204%2F13%2C%20and%20I%20have%20to%20manual%20reference%204%2F21.%20Is%20it%20possible%20to%20have%20this%20automatically%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22datawizsmh_0-1620324172376.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278845i442986A90B83D313%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22datawizsmh_0-1620324172376.png%22%20alt%3D%22datawizsmh_0-1620324172376.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2332496%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2332679%22%20slang%3D%22en-US%22%3ERe%3A%20date%20populate%20based%20on%20what%20the%20user%20enters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2332679%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047173%22%20target%3D%22_blank%22%3E%40datawizsmh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20on%20Excel%20365%20that%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSEQUENCE(B1-D1%2B1%2C1%2CB1%2C-1)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EIf%20not%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(ROW()-ROW(%24B%242)%26gt%3B%24B%241-%24D%241%2B1%2C%22%22%2C%24B%241-ROW()%2BROW(%24B%242)%2B1)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Ecould%20work.%20Please%20check%20in%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2332777%22%20slang%3D%22en-US%22%3ERe%3A%20date%20populate%20based%20on%20what%20the%20user%20enters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2332777%22%20slang%3D%22en-US%22%3EThank%20you!%20The%20second%20one%20works!%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello, I am trying to have the date populate based on what the user enters (see below). I used the formula =IF(ROW(A1)>=$B$2,"",DAYS($A$4,ROW(A1))) but as you can see it includes dates past 4/13, and I have to manual reference 4/21. Is it possible to have this automatically?

 

datawizsmh_0-1620324172376.png

 

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@datawizsmh 

If you are on Excel 365 that could be

=SEQUENCE(B1-D1+1,1,B1,-1)

If not

=IF(ROW()-ROW($B$2)>$B$1-$D$1+1,"",$B$1-ROW()+ROW($B$2)+1)

could work. Please check in attached.

Thank you! The second one works!

@datawizsmh , you are welcome