<div>
Type the first date into A5.<br />
<br />
Put this formula into A6.<br />
=IF(A5&lt;A$5+B$1-1,A5+1,&quot;&quot;)<br />
<br />
&nbsp;Copy the formula down as far as you may need to go (the maximum number):
</div>


Type the first date into A5.

Put this formula into A6.
=IF(A5<A$5+B$1-1,A5+1,"")

 Copy the formula down as far as you may need to go (the maximum number):

<div>
Thank you, but there is one thing i forgot the mention:<br />
<br />
The value in B1 (&quot;Number of times to repeat&quot;) could be zero. In this case, there would be nothing in cell A5.<br />
<br />
Sorry for the confusion.
</div>


Thank you, but there is one thing i forgot the mention:

The value in B1 ("Number of times to repeat") could be zero. In this case, there would be nothing in cell A5.

Sorry for the confusion.

<div>
What determines the first date? Is it always 1/1/16? The first date of the current year?
</div>


What determines the first date? Is it always 1/1/16? The first date of the current year?

<div>
Hi,<br />
<br />
Assuming B1 is not Zero, the first date in A5 would be today's date + 30 days.
</div>


Hi,

Assuming B1 is not Zero, the first date in A5 would be today's date + 30 days.

<div>
In that case, change the formula in A5 with the following one.....<br />
<br />

<pre><code id="code-20-41759708-1">=IF($B$1=&quot;&quot;,&quot;&quot;,TODAY()+30)</code></pre>
</div>


In that case, change the formula in A5 with the following one.....



=IF($B$1="","",TODAY()+30)

<div>
You're welcome. Glad to help.
</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I have a fixed number in cell B1. <br />
<br />
How do i repeat values (starting at A5) until the fixed value in cell B1 is reached?<br />
<br />
Thanks in advance.<br />
<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2016/08_w34/1111970/__Excel.jpg" target="_blank" title="screen (17 KB)"><img alt="screen" class="file-block lazyload" style="max-width: 403px;" data-src="https://filedb.experts-exchange.com/incoming/2016/08_w34/1111970/__Excel.jpg" /></a>
</div>
</div>


__Excel.jpg

Hi all,

I have a fixed number in cell B1. 

How do i repeat values (starting at A5) until the fixed value in cell B1 is reached?

Thanks in advance.

 

Excel - repeat entries until a fixed number is reached.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

An email client, email reader or more formally mail user agent (MUA) is a computer program used to access and manage a user's email. A web application that provides message management, composition, and reception functions is sometimes also considered an email client, but more commonly referred to as webmail.