<div>
Well, you can start with:<br />
=DATE(2014,10,8)<br />
<br />
if you wanted row 1 to be 2014 you could do row() + 2013 for the year . . . or some offset of that kind.<br />
<br />
Not sure what you mean by dynamic other then the year has to change.
</div>


Well, you can start with:
=DATE(2014,10,8)

if you wanted row 1 to be 2014 you could do row() + 2013 for the year . . . or some offset of that kind.

Not sure what you mean by dynamic other then the year has to change.

<div>
Kyle, thanks. &nbsp;2014 is hard coded and I really need something dynamic. &nbsp;Maybe Now()?
</div>


Kyle, thanks.  2014 is hard coded and I really need something dynamic.  Maybe Now()?

<div>
something like: <br />
=DATE(NOw(),10,8)) &nbsp;but I dont think that is the answer
</div>


something like:
=DATE(NOw(),10,8))  but I dont think that is the answer

<div>
Olemo is correct . . . year(Today()) would get you the current year.
</div>


Olemo is correct . . . year(Today()) would get you the current year.

<div>
<div class="content wysiwyg-content">
experts, what would be the formula to arrive at Oct 8 of each year? &nbsp;It must be dynamic formula and not entered simply as Oct 8, 2014 and change for each year after that. &nbsp;<br />
<br />
thank you
</div>
</div>


experts, what would be the formula to arrive at Oct 8 of each year?  It must be dynamic formula and not entered simply as Oct 8, 2014 and change for each year after that.  

thank you

Oct 8 of each year

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