Excel Formulas to Generate a Series of Dates by Custom Days ~ Easily!!

Have you ever tried to generate a series of dates by custom days in Excel? In this article, we will show the easiest way to generate a dynamic series of dates that include only certain days of the week. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
  • You can use the below formula to generate a dynamic series of dates that include only certain days of the week in Excel.
  • =WORKDAY.INTL(A1,1,”0010111″)
    Syntax Explanations:
  • WORKDAY.INTL – This function helps to calculate the proximate working day based on the values we provide and returns a number that represents the date. Read more on WORKDAY.INTL Function.
  • A1 – It represents the input date from your worksheet.
  • Comma symbol (,) – It is a separator that helps to separate a list of values.
  • Parenthesis () – The main purpose of this symbol is to group the elements.
  • Example:
    Refer to the below example image.
  • First, we will enter the input starting date in Column B.
  • Here, we have to create a dynamic series of dates that include only certain days of the week (i.e. only Monday, Tuesday, and Thursdays).
  • So, apply the above-given formula and press the ENTER key.
  • Finally, you will get the result as shown below.
  • Bottom-Line:
    From this guide, you can get some clarification on how to generate a series of dates that include only custom days of the week in Excel. I hope that this article is useful. If you have any doubts regarding this topic or any other Excel VBA-related topic, ask in the comments section below.
    Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
    Read Ahead:

    30

    This website collects cookies to deliver better user experience

    Excel Formulas to Generate a Series of Dates by Custom Days ~ Easily!!