How can I autofill dates in Excel excluding Sunday? The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Compute SLA between dates including weekendsAutofill date pattern with ExcelHow to autofill a start and end date where both values are within one cell? ExcelHow to determine next Delivery date based off today's dateExcel fill dates except SundayCan you autofill numbers going upward?How to format historical dates in Excel?Pivot table Date Filter- Force 'This Week' to MondayExcel dates in sequential ordersConditional formatting on dates in Excel 2013

How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time

Single author papers against my advisor's will?

Does Parliament hold absolute power in the UK?

Do working physicists consider Newtonian mechanics to be "falsified"?

how can a perfect fourth interval be considered either consonant or dissonant?

system() function string length limit

How did passengers keep warm on sail ships?

Would it be possible to rearrange a dragon's flight muscle to somewhat circumvent the square-cube law?

Windows 10: How to Lock (not sleep) laptop on lid close?

Do warforged have souls?

Did the UK government pay "millions and millions of dollars" to try to snag Julian Assange?

How to test the equality of two Pearson correlation coefficients computed from the same sample?

Take groceries in checked luggage

How are presidential pardons supposed to be used?

Python - Fishing Simulator

Can a novice safely splice in wire to lengthen 5V charging cable?

Match Roman Numerals

University's motivation for having tenure-track positions

Is this wall load bearing? Blueprints and photos attached

Why can't wing-mounted spoilers be used to steepen approaches?

Keeping a retro style to sci-fi spaceships?

Why not take a picture of a closer black hole?

Change bounding box of math glyphs in LuaTeX

A pet rabbit called Belle



How can I autofill dates in Excel excluding Sunday?



The 2019 Stack Overflow Developer Survey Results Are In
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Compute SLA between dates including weekendsAutofill date pattern with ExcelHow to autofill a start and end date where both values are within one cell? ExcelHow to determine next Delivery date based off today's dateExcel fill dates except SundayCan you autofill numbers going upward?How to format historical dates in Excel?Pivot table Date Filter- Force 'This Week' to MondayExcel dates in sequential ordersConditional formatting on dates in Excel 2013



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








5















How do I autofill a list of sequential dates in Excel excluding Sunday? I want Monday April 8 to Saturday April 13, then back to Monday April 15.










share|improve this question









New contributor




Quy Nguyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.


























    5















    How do I autofill a list of sequential dates in Excel excluding Sunday? I want Monday April 8 to Saturday April 13, then back to Monday April 15.










    share|improve this question









    New contributor




    Quy Nguyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.






















      5












      5








      5








      How do I autofill a list of sequential dates in Excel excluding Sunday? I want Monday April 8 to Saturday April 13, then back to Monday April 15.










      share|improve this question









      New contributor




      Quy Nguyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      How do I autofill a list of sequential dates in Excel excluding Sunday? I want Monday April 8 to Saturday April 13, then back to Monday April 15.







      microsoft-excel






      share|improve this question









      New contributor




      Quy Nguyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question









      New contributor




      Quy Nguyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question








      edited Apr 10 at 16:53









      fixer1234

      19.5k145082




      19.5k145082






      New contributor




      Quy Nguyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked Apr 10 at 16:45









      Quy NguyenQuy Nguyen

      261




      261




      New contributor




      Quy Nguyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Quy Nguyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Quy Nguyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.




















          2 Answers
          2






          active

          oldest

          votes


















          7














          Here is a basic way to do it



          Fill the dates for the first week in the first six rows (say A2 to A7).



          In the seventh row, insert the following formula:



          =A2+7


          And populate down



          Another way is to insert the first day in A2 then use the following formula



          =IF(WEEKDAY(A2+1)=1,A2+2,A2+1)


          and again, populate down






          share|improve this answer


















          • 5





            Yet another variant of the second: =A2+1+(WEEKDAY(A2+1)=1)*1

            – Hannu
            Apr 10 at 18:49







          • 1





            oooh! Clever use of the true/false numerical values, hadn't thought of that one

            – cybernetic.nomad
            Apr 10 at 18:51











          • Yes, it also opens up for more complex series generation.

            – Hannu
            Apr 10 at 18:52


















          0














          Your problem can be solved by using below shown method also:



          enter image description here



          How it works:



          • Enter start date, 04/08/2019 in Cell A1
            (Cell Format is mm/dd/yyyy).


          • Write this Formula in Cell A2 & fill it down
            till you need.



            =IF(WEEKDAY(A1,2)<>6,A1+1,A1+2)




          • Enter this formula in Cell C1 to
            justify the Formula in Column A, and
            fill it Down also.



            =TEXT(WEEKDAY(A1,1),"DDDD")



          Adjust cell references in the Formula as needed.






          share|improve this answer

























            Your Answer








            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "3"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );






            Quy Nguyen is a new contributor. Be nice, and check out our Code of Conduct.









            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1423868%2fhow-can-i-autofill-dates-in-excel-excluding-sunday%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            7














            Here is a basic way to do it



            Fill the dates for the first week in the first six rows (say A2 to A7).



            In the seventh row, insert the following formula:



            =A2+7


            And populate down



            Another way is to insert the first day in A2 then use the following formula



            =IF(WEEKDAY(A2+1)=1,A2+2,A2+1)


            and again, populate down






            share|improve this answer


















            • 5





              Yet another variant of the second: =A2+1+(WEEKDAY(A2+1)=1)*1

              – Hannu
              Apr 10 at 18:49







            • 1





              oooh! Clever use of the true/false numerical values, hadn't thought of that one

              – cybernetic.nomad
              Apr 10 at 18:51











            • Yes, it also opens up for more complex series generation.

              – Hannu
              Apr 10 at 18:52















            7














            Here is a basic way to do it



            Fill the dates for the first week in the first six rows (say A2 to A7).



            In the seventh row, insert the following formula:



            =A2+7


            And populate down



            Another way is to insert the first day in A2 then use the following formula



            =IF(WEEKDAY(A2+1)=1,A2+2,A2+1)


            and again, populate down






            share|improve this answer


















            • 5





              Yet another variant of the second: =A2+1+(WEEKDAY(A2+1)=1)*1

              – Hannu
              Apr 10 at 18:49







            • 1





              oooh! Clever use of the true/false numerical values, hadn't thought of that one

              – cybernetic.nomad
              Apr 10 at 18:51











            • Yes, it also opens up for more complex series generation.

              – Hannu
              Apr 10 at 18:52













            7












            7








            7







            Here is a basic way to do it



            Fill the dates for the first week in the first six rows (say A2 to A7).



            In the seventh row, insert the following formula:



            =A2+7


            And populate down



            Another way is to insert the first day in A2 then use the following formula



            =IF(WEEKDAY(A2+1)=1,A2+2,A2+1)


            and again, populate down






            share|improve this answer













            Here is a basic way to do it



            Fill the dates for the first week in the first six rows (say A2 to A7).



            In the seventh row, insert the following formula:



            =A2+7


            And populate down



            Another way is to insert the first day in A2 then use the following formula



            =IF(WEEKDAY(A2+1)=1,A2+2,A2+1)


            and again, populate down







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Apr 10 at 16:50









            cybernetic.nomadcybernetic.nomad

            2,799617




            2,799617







            • 5





              Yet another variant of the second: =A2+1+(WEEKDAY(A2+1)=1)*1

              – Hannu
              Apr 10 at 18:49







            • 1





              oooh! Clever use of the true/false numerical values, hadn't thought of that one

              – cybernetic.nomad
              Apr 10 at 18:51











            • Yes, it also opens up for more complex series generation.

              – Hannu
              Apr 10 at 18:52












            • 5





              Yet another variant of the second: =A2+1+(WEEKDAY(A2+1)=1)*1

              – Hannu
              Apr 10 at 18:49







            • 1





              oooh! Clever use of the true/false numerical values, hadn't thought of that one

              – cybernetic.nomad
              Apr 10 at 18:51











            • Yes, it also opens up for more complex series generation.

              – Hannu
              Apr 10 at 18:52







            5




            5





            Yet another variant of the second: =A2+1+(WEEKDAY(A2+1)=1)*1

            – Hannu
            Apr 10 at 18:49






            Yet another variant of the second: =A2+1+(WEEKDAY(A2+1)=1)*1

            – Hannu
            Apr 10 at 18:49





            1




            1





            oooh! Clever use of the true/false numerical values, hadn't thought of that one

            – cybernetic.nomad
            Apr 10 at 18:51





            oooh! Clever use of the true/false numerical values, hadn't thought of that one

            – cybernetic.nomad
            Apr 10 at 18:51













            Yes, it also opens up for more complex series generation.

            – Hannu
            Apr 10 at 18:52





            Yes, it also opens up for more complex series generation.

            – Hannu
            Apr 10 at 18:52













            0














            Your problem can be solved by using below shown method also:



            enter image description here



            How it works:



            • Enter start date, 04/08/2019 in Cell A1
              (Cell Format is mm/dd/yyyy).


            • Write this Formula in Cell A2 & fill it down
              till you need.



              =IF(WEEKDAY(A1,2)<>6,A1+1,A1+2)




            • Enter this formula in Cell C1 to
              justify the Formula in Column A, and
              fill it Down also.



              =TEXT(WEEKDAY(A1,1),"DDDD")



            Adjust cell references in the Formula as needed.






            share|improve this answer





























              0














              Your problem can be solved by using below shown method also:



              enter image description here



              How it works:



              • Enter start date, 04/08/2019 in Cell A1
                (Cell Format is mm/dd/yyyy).


              • Write this Formula in Cell A2 & fill it down
                till you need.



                =IF(WEEKDAY(A1,2)<>6,A1+1,A1+2)




              • Enter this formula in Cell C1 to
                justify the Formula in Column A, and
                fill it Down also.



                =TEXT(WEEKDAY(A1,1),"DDDD")



              Adjust cell references in the Formula as needed.






              share|improve this answer



























                0












                0








                0







                Your problem can be solved by using below shown method also:



                enter image description here



                How it works:



                • Enter start date, 04/08/2019 in Cell A1
                  (Cell Format is mm/dd/yyyy).


                • Write this Formula in Cell A2 & fill it down
                  till you need.



                  =IF(WEEKDAY(A1,2)<>6,A1+1,A1+2)




                • Enter this formula in Cell C1 to
                  justify the Formula in Column A, and
                  fill it Down also.



                  =TEXT(WEEKDAY(A1,1),"DDDD")



                Adjust cell references in the Formula as needed.






                share|improve this answer















                Your problem can be solved by using below shown method also:



                enter image description here



                How it works:



                • Enter start date, 04/08/2019 in Cell A1
                  (Cell Format is mm/dd/yyyy).


                • Write this Formula in Cell A2 & fill it down
                  till you need.



                  =IF(WEEKDAY(A1,2)<>6,A1+1,A1+2)




                • Enter this formula in Cell C1 to
                  justify the Formula in Column A, and
                  fill it Down also.



                  =TEXT(WEEKDAY(A1,1),"DDDD")



                Adjust cell references in the Formula as needed.







                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited 2 days ago

























                answered 2 days ago









                Rajesh SRajesh S

                4,4582725




                4,4582725




















                    Quy Nguyen is a new contributor. Be nice, and check out our Code of Conduct.









                    draft saved

                    draft discarded


















                    Quy Nguyen is a new contributor. Be nice, and check out our Code of Conduct.












                    Quy Nguyen is a new contributor. Be nice, and check out our Code of Conduct.











                    Quy Nguyen is a new contributor. Be nice, and check out our Code of Conduct.














                    Thanks for contributing an answer to Super User!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1423868%2fhow-can-i-autofill-dates-in-excel-excluding-sunday%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Tamil (spriik) Luke uk diar | Nawigatjuun

                    Align equal signs while including text over equalitiesAMS align: left aligned text/math plus multicolumn alignmentMultiple alignmentsAligning equations in multiple placesNumbering and aligning an equation with multiple columnsHow to align one equation with another multline equationUsing \ in environments inside the begintabularxNumber equations and preserving alignment of equal signsHow can I align equations to the left and to the right?Double equation alignment problem within align enviromentAligned within align: Why are they right-aligned?

                    Training a classifier when some of the features are unknownWhy does Gradient Boosting regression predict negative values when there are no negative y-values in my training set?How to improve an existing (trained) classifier?What is effect when I set up some self defined predisctor variables?Why Matlab neural network classification returns decimal values on prediction dataset?Fitting and transforming text data in training, testing, and validation setsHow to quantify the performance of the classifier (multi-class SVM) using the test data?How do I control for some patients providing multiple samples in my training data?Training and Test setTraining a convolutional neural network for image denoising in MatlabShouldn't an autoencoder with #(neurons in hidden layer) = #(neurons in input layer) be “perfect”?